Pandas Profiling Report

Dataset info

Number of variables	181
Number of observations	566
Missing cells	35172 (34.3%)
Duplicate rows	0 (0.0%)
Total size in memory	762.9 KiB
Average record size in memory	1.3 KiB

Variables types

Numeric	69
Categorical	20
Boolean	15
Date	0
URL	0
Text (Unique)	1
Rejected	76
Unsupported	0

Warnings

`coligada_mais_antiga_ativa` has 267 (47.2%) missing values	Missing
`coligada_mais_antiga_baixada` has constant value "nan"	Rejected
`coligada_mais_nova_ativa` has 267 (47.2%) missing values	Missing
`coligada_mais_nova_baixada` has constant value "nan"	Rejected
`de_indicador_telefone` has constant value "BOA"	Rejected
`de_saude_rescencia` has constant value "ACIMA DE 1 ANO"	Rejected
`dt_situacao` only contains datetime values, but is categorical. Consider applying `pd.to_datetime()`	Type
`dt_situacao` has a high cardinality: 207 distinct values	Warning
`empsetorcensitariofaixarendapopulacao` has 70 (12.4%) missing values	Missing
`faturamento_est_coligados` has 273 (48.2%) missing values	Missing
`faturamento_est_coligados_gp` is highly correlated with `faturamento_est_coligados` (ρ = 0.96717)	Rejected
`fl_epp` has constant value "False"	Rejected
`fl_matriz` has constant value "True"	Rejected
`fl_mei` has constant value "False"	Rejected
`fl_optante_simei` has constant value "False"	Rejected
`grau_instrucao_macro_analfabeto` has 449 (79.3%) missing values	Missing
`grau_instrucao_macro_desconhecido` has constant value "nan"	Rejected
`grau_instrucao_macro_escolaridade_fundamental` has 48 (8.5%) missing values	Missing
`grau_instrucao_macro_escolaridade_superior` has 17 (3.0%) missing values	Missing
`idade_acima_de_58` has 61 (10.8%) missing values	Missing
`idade_ate_18` has 351 (62.0%) missing values	Missing
`idade_de_19_a_23` has 94 (16.6%) missing values	Missing
`idade_de_24_a_28` has 17 (3.0%) missing values	Missing
`idade_de_39_a_43` is highly correlated with `idade_de_34_a_38` (ρ = 0.95905)	Rejected
`idade_de_44_a_48` is highly correlated with `idade_de_39_a_43` (ρ = 0.98342)	Rejected
`idade_de_49_a_53` is highly correlated with `idade_de_44_a_48` (ρ = 0.99027)	Rejected
`idade_de_54_a_58` is highly correlated with `idade_de_49_a_53` (ρ = 0.98514)	Rejected
`idade_maxima_coligadas` is highly correlated with `coligada_mais_antiga_ativa` (ρ = 0.99911)	Rejected
`idade_maxima_socios` has 213 (37.6%) missing values	Missing
`idade_media_coligadas` has 267 (47.2%) missing values	Missing
`idade_media_coligadas_ativas` is highly correlated with `idade_media_coligadas` (ρ = 0.9995)	Rejected
`idade_media_coligadas_baixadas` has constant value "nan"	Rejected
`idade_media_socios` has 213 (37.6%) missing values	Missing
`idade_minima_coligadas` is highly correlated with `coligada_mais_nova_ativa` (ρ = 0.99963)	Rejected
`idade_minima_socios` has 213 (37.6%) missing values	Missing
`max_faturamento_est_coligados` has 273 (48.2%) missing values	Missing
`max_faturamento_est_coligados_gp` is highly correlated with `max_faturamento_est_coligados` (ρ = 0.94873)	Rejected
`max_filiais_coligados` is highly correlated with `max_faturamento_est_coligados_gp` (ρ = 0.92095)	Rejected
`max_funcionarios_coligados_gp` is highly correlated with `max_filiais_coligados` (ρ = 0.95968)	Rejected
`max_vl_folha_coligados` has 332 (58.7%) missing values	Missing
`max_vl_folha_coligados_gp` is highly correlated with `max_faturamento_est_coligados_gp` (ρ = 0.9326)	Rejected
`media_faturamento_est_coligados` has 273 (48.2%) missing values	Missing
`media_faturamento_est_coligados_gp` is highly correlated with `media_faturamento_est_coligados` (ρ = 0.97553)	Rejected
`media_filiais_coligados` is highly correlated with `media_faturamento_est_coligados_gp` (ρ = 0.93788)	Rejected
`media_funcionarios_coligados_gp` is highly correlated with `media_filiais_coligados` (ρ = 0.97637)	Rejected
`media_vl_folha_coligados` has 332 (58.7%) missing values	Missing
`media_vl_folha_coligados_gp` is highly correlated with `media_faturamento_est_coligados_gp` (ρ = 0.93982)	Rejected
`min_faturamento_est_coligados` has 273 (48.2%) missing values	Missing
`min_faturamento_est_coligados_gp` is highly correlated with `min_faturamento_est_coligados` (ρ = 0.94763)	Rejected
`min_filiais_coligados` has 413 (73.0%) missing values	Missing
`min_funcionarios_coligados_gp` has 93 (16.4%) zeros	Zeros
`min_funcionarios_coligados_gp` has 314 (55.5%) missing values	Missing
`min_meses_servicos` is highly correlated with `meses_ultima_contratacaco` (ρ = 0.98348)	Rejected
`min_meses_servicos_all` has 35 (6.2%) zeros	Zeros
`min_vl_folha_coligados` is highly correlated with `media_vl_folha_coligados` (ρ = 0.92717)	Rejected
`min_vl_folha_coligados_gp` is highly correlated with `min_vl_folha_coligados` (ρ = 0.95645)	Rejected
`nm_divisao` has a high cardinality: 60 distinct values	Warning
`nm_meso_regiao` has 70 (12.4%) missing values	Missing
`nm_micro_regiao` has a high cardinality: 61 distinct values	Warning
`nm_micro_regiao` has 70 (12.4%) missing values	Missing
`qt_admitidos_12meses` has 199 (35.2%) zeros	Zeros
`qt_alteracao_socio_180d` has constant value "nan"	Rejected
`qt_alteracao_socio_365d` has constant value "nan"	Rejected
`qt_alteracao_socio_90d` has constant value "nan"	Rejected
`qt_alteracao_socio_total` has constant value "nan"	Rejected
`qt_art` has 304 (53.7%) missing values	Missing
`qt_coligadas` has 267 (47.2%) missing values	Missing
`qt_coligados` is highly correlated with `qt_coligadas` (ρ = 1)	Rejected
`qt_coligados_agropecuaria` has 265 (46.8%) zeros	Zeros
`qt_coligados_agropecuaria` has 267 (47.2%) missing values	Missing
`qt_coligados_atividade_alto` has constant value "0.0"	Rejected
`qt_coligados_atividade_baixo` has constant value "0.0"	Rejected
`qt_coligados_atividade_inativo` has constant value "0.0"	Rejected
`qt_coligados_atividade_medio` has constant value "0.0"	Rejected
`qt_coligados_atividade_mt_baixo` has constant value "0.0"	Rejected
`qt_coligados_ativo` is highly correlated with `qt_coligados` (ρ = 0.99984)	Rejected
`qt_coligados_baixada` has 267 (47.2%) missing values	Missing
`qt_coligados_ccivil` has 220 (38.9%) zeros	Zeros
`qt_coligados_ccivil` has 267 (47.2%) missing values	Missing
`qt_coligados_centro` has 272 (48.1%) zeros	Zeros
`qt_coligados_centro` has 267 (47.2%) missing values	Missing
`qt_coligados_comercio` has 152 (26.9%) zeros	Zeros
`qt_coligados_comercio` has 267 (47.2%) missing values	Missing
`qt_coligados_epp` has constant value "0.0"	Rejected
`qt_coligados_exterior` has 267 (47.2%) missing values	Missing
`qt_coligados_inapta` has 267 (47.2%) missing values	Missing
`qt_coligados_industria` has 211 (37.3%) zeros	Zeros
`qt_coligados_industria` has 267 (47.2%) missing values	Missing
`qt_coligados_ltda` has 286 (50.5%) zeros	Zeros
`qt_coligados_ltda` has 267 (47.2%) missing values	Missing
`qt_coligados_matriz` is highly correlated with `qt_coligados_ativo` (ρ = 0.99904)	Rejected
`qt_coligados_me` has constant value "0.0"	Rejected
`qt_coligados_mei` has 267 (47.2%) missing values	Missing
`qt_coligados_nordeste` has 141 (24.9%) zeros	Zeros
`qt_coligados_nordeste` has 267 (47.2%) missing values	Missing
`qt_coligados_norte` has 159 (28.1%) zeros	Zeros
`qt_coligados_norte` has 267 (47.2%) missing values	Missing
`qt_coligados_nula` has constant value "0.0"	Rejected
`qt_coligados_sa` is highly correlated with `qt_coligados_industria` (ρ = 0.92957)	Rejected
`qt_coligados_serviço` has 61 (10.8%) zeros	Zeros
`qt_coligados_serviço` has 267 (47.2%) missing values	Missing
`qt_coligados_sudeste` is highly correlated with `qt_coligados_matriz` (ρ = 0.92867)	Rejected
`qt_coligados_sul` has 287 (50.7%) zeros	Zeros
`qt_coligados_sul` has 267 (47.2%) missing values	Missing
`qt_coligados_suspensa` has constant value "0.0"	Rejected
`qt_desligados_12meses` has 187 (33.0%) zeros	Zeros
`qt_ex_funcionarios` is highly correlated with `qt_desligados` (ρ = 1)	Rejected
`qt_filiais` has 270 (47.7%) zeros	Zeros
`qt_funcionarios` is highly correlated with `idade_de_54_a_58` (ρ = 0.94732)	Rejected
`qt_funcionarios_12meses` is highly correlated with `qt_funcionarios` (ρ = 0.99761)	Rejected
`qt_funcionarios_24meses` is highly correlated with `qt_funcionarios_12meses` (ρ = 0.98334)	Rejected
`qt_funcionarios_coligados` has 18 (3.2%) zeros	Zeros
`qt_funcionarios_coligados` has 314 (55.5%) missing values	Missing
`qt_funcionarios_coligados_gp` is highly correlated with `media_filiais_coligados` (ρ = 0.90605)	Rejected
`qt_funcionarios_grupo` is highly skewed (γ1 = 21.811)	Skewed
`qt_ramos_coligados` has 267 (47.2%) missing values	Missing
`qt_regioes_coligados` has 267 (47.2%) missing values	Missing
`qt_socios` has 184 (32.5%) missing values	Missing
`qt_socios_coligados` is highly correlated with `qt_coligados_matriz` (ρ = 0.96791)	Rejected
`qt_socios_feminino` is highly correlated with `qt_socios` (ρ = 0.98778)	Rejected
`qt_socios_masculino` is highly correlated with `qt_socios_feminino` (ρ = 0.96613)	Rejected
`qt_socios_pep` is highly correlated with `qt_socios_masculino` (ρ = 0.97676)	Rejected
`qt_socios_pf` is highly correlated with `qt_socios_pep` (ρ = 0.9745)	Rejected
`qt_socios_pj` has 184 (32.5%) missing values	Missing
`qt_socios_pj_ativos` is highly correlated with `qt_socios_pj` (ρ = 0.96283)	Rejected
`qt_socios_pj_baixados` has 515 (91.0%) missing values	Missing
`qt_socios_pj_inaptos` has constant value "0.0"	Rejected
`qt_socios_pj_nulos` has constant value "0.0"	Rejected
`qt_socios_pj_suspensos` has constant value "0.0"	Rejected
`qt_socios_st_regular` is highly correlated with `qt_socios_pf` (ρ = 0.99433)	Rejected
`qt_socios_st_suspensa` has constant value "nan"	Rejected
`qt_ufs_coligados` has 267 (47.2%) missing values	Missing
`sum_faturamento_estimado_coligadas` is highly correlated with `faturamento_est_coligados_gp` (ρ = 0.96717)	Rejected
`total` is highly correlated with `qt_funcionarios_24meses` (ρ = 0.97843)	Rejected
`total_filiais_coligados` is highly correlated with `qt_funcionarios_coligados_gp` (ρ = 0.92158)	Rejected
`tx_crescimento_12meses` has 195 (34.5%) zeros	Zeros
`tx_crescimento_24meses` is highly correlated with `qt_socios_pep` (ρ = 0.96385)	Rejected
`tx_rotatividade` has 188 (33.2%) zeros	Zeros
`vl_folha_coligados` is highly correlated with `qt_funcionarios_coligados` (ρ = 0.92165)	Rejected
`vl_folha_coligados_gp` is highly correlated with `max_vl_folha_coligados_gp` (ρ = 0.90572)	Rejected
`vl_frota` has 98 (17.3%) missing values	Missing
`vl_idade_maxima_socios_pj` has 515 (91.0%) missing values	Missing
`vl_idade_media_socios_pj` is highly correlated with `vl_idade_maxima_socios_pj` (ρ = 0.93323)	Rejected
`vl_idade_minima_socios_pj` is highly correlated with `vl_idade_media_socios_pj` (ρ = 0.92519)	Rejected
`vl_potenc_cons_oleo_gas` has 472 (83.4%) missing values	Missing
`vl_total_tancagem` is highly correlated with `vl_potenc_cons_oleo_gas` (ρ = 0.94313)	Rejected
`vl_total_tancagem_grupo` has 536 (94.7%) missing values	Missing
`vl_total_veiculos_antt` is highly correlated with `vl_total_tancagem_grupo` (ρ = 0.9644)	Rejected
`vl_total_veiculos_antt_grupo` is highly correlated with `vl_total_veiculos_antt` (ρ = 1)	Rejected
`vl_total_veiculos_leves` has 47 (8.3%) zeros	Zeros
`vl_total_veiculos_leves` has 76 (13.4%) missing values	Missing
`vl_total_veiculos_leves_grupo` is highly correlated with `vl_total_veiculos_leves` (ρ = 0.95902)	Rejected
`vl_total_veiculos_pesados` has 165 (29.2%) zeros	Zeros
`vl_total_veiculos_pesados` has 76 (13.4%) missing values	Missing
`vl_total_veiculos_pesados_grupo` has 237 (41.9%) zeros	Zeros

coligada_mais_antiga_ativa
Numeric

Distinct count	292
Unique (%)	51.6%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	299.87
Minimum	2.7667
Maximum	1135.2
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2.7667
5-th percentile	35.37
Q1	151.27
Median	275.47
Q3	432.65
95-th percentile	630.89
Maximum	1135.2
Range	1132.5
Interquartile range	281.38

Descriptive statistics

Standard deviation	187.5
Coef of variation	0.62528
Kurtosis	0.16843
Mean	299.87
MAD	153.49
Skewness	0.55723
Sum	89661
Variance	35156
Memory size	8.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
500.13	2	0.4%
101.83	2	0.4%
635.23	2	0.4%
438.73	2	0.4%
657.87	2	0.4%
261.03	2	0.4%
186.8	2	0.4%
634.5	2	0.4%
336.43	1	0.2%
361.73	1	0.2%
Other values (281)	281	49.6%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
2.7667	1	0.2%
5.8	1	0.2%
8.9333	1	0.2%
11.133	1	0.2%
17.133	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
1135.2	1	0.2%
674.93	1	0.2%
657.87	2	0.4%
642.67	1	0.2%
636.83	1	0.2%

coligada_mais_antiga_baixada
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

coligada_mais_nova_ativa
Numeric

Distinct count	282
Unique (%)	49.8%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	86.911
Minimum	1.5
Maximum	614
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1.5
5-th percentile	3.19
Q1	21.367
Median	56.2
Q3	116.25
95-th percentile	287.9
Maximum	614
Range	612.5
Interquartile range	94.883

Descriptive statistics

Standard deviation	91.556
Coef of variation	1.0534
Kurtosis	4.7987
Mean	86.911
MAD	66.987
Skewness	1.9204
Sum	25986
Variance	8382.6
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
56.9	2	0.4%
14.567	2	0.4%
2.0333	2	0.4%
2.7667	2	0.4%
237.43	2	0.4%
4.8	2	0.4%
186.8	2	0.4%
47.8	2	0.4%
9.4667	2	0.4%
17.933	2	0.4%
Other values (271)	279	49.3%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
1.5	2	0.4%
1.6	1	0.2%
1.9667	1	0.2%
2.0333	2	0.4%
2.4	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
614	1	0.2%
424.63	1	0.2%
378.13	1	0.2%
377.9	1	0.2%
368.87	1	0.2%

coligada_mais_nova_baixada
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

de_faixa_faturamento_estimado
Categorical

Distinct count	6
Unique (%)	1.1%
Missing (%)	0.0%
Missing (n)	0

DE R$ 10.000.000,01 A R$ 30.000.000,00	278
DE R$ 30.000.000,01 A R$ 100.000.000,00	202
DE R$ 100.000.000,01 A R$ 300.000.000,00	58
Other values (3)	28

Toggle details

Common values
Composition

Value	Count	Frequency (%)
DE R$ 10.000.000,01 A R$ 30.000.000,00	278	49.1%
DE R$ 30.000.000,01 A R$ 100.000.000,00	202	35.7%
DE R$ 100.000.000,01 A R$ 300.000.000,00	58	10.2%
DE R$ 300.000.000,01 A R$ 500.000.000,00	15	2.7%
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS	8	1.4%
ACIMA DE 1 BILHAO DE REAIS	5	0.9%

Max length	40
Mean length	38.537
Min length	26
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

de_faixa_faturamento_estimado_grupo
Categorical

Distinct count	6
Unique (%)	1.1%
Missing (%)	0.0%
Missing (n)	0

DE R$ 10.000.000,01 A R$ 30.000.000,00	247
DE R$ 30.000.000,01 A R$ 100.000.000,00	210
DE R$ 100.000.000,01 A R$ 300.000.000,00	78
Other values (3)	31

Toggle details

Common values
Composition

Value	Count	Frequency (%)
DE R$ 10.000.000,01 A R$ 30.000.000,00	247	43.6%
DE R$ 30.000.000,01 A R$ 100.000.000,00	210	37.1%
DE R$ 100.000.000,01 A R$ 300.000.000,00	78	13.8%
DE R$ 300.000.000,01 A R$ 500.000.000,00	14	2.5%
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS	9	1.6%
ACIMA DE 1 BILHAO DE REAIS	8	1.4%

Max length	40
Mean length	38.558
Min length	26
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

de_indicador_telefone
Constant

This variable is constant and should be ignored for analysis

Constant value	BOA

de_natureza_juridica
Categorical

Distinct count	26
Unique (%)	4.6%
Missing (%)	0.0%
Missing (n)	0

SOCIEDADE EMPRESARIA LIMITADA	287
MUNICIPIO	110
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA	31
Other values (23)	138

Toggle details

Common values
Composition

Value	Count	Frequency (%)
SOCIEDADE EMPRESARIA LIMITADA	287	50.7%
MUNICIPIO	110	19.4%
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA	31	5.5%
ASSOCIACAO PRIVADA	21	3.7%
SOCIEDADE ANONIMA FECHADA	21	3.7%
ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL	19	3.4%
ORGAO PUBLICO DO PODER EXECUTIVO MUNICIPAL	12	2.1%
EMPRESARIO INDIVIDUAL	10	1.8%
SOCIEDADE SIMPLES LIMITADA	6	1.1%
FUNDO PUBLICO	6	1.1%
Other values (16)	43	7.6%

Max length	70
Mean length	27.896
Min length	9
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

de_nivel_atividade
Categorical

Distinct count	3
Unique (%)	0.5%
Missing (%)	0.0%
Missing (n)	0

ALTA	523
MEDIA	37
BAIXA	6

Toggle details

Common values
Composition

Value	Count	Frequency (%)
ALTA	523	92.4%
MEDIA	37	6.5%
BAIXA	6	1.1%

Max length	5
Mean length	4.076
Min length	4
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

de_ramo
Categorical

Distinct count	29
Unique (%)	5.1%
Missing (%)	0.0%
Missing (n)	0

ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	163
INDUSTRIA DA CONSTRUCAO	46
COMERCIO VAREJISTA	46
Other values (26)	311

Toggle details

Common values
Composition

Value	Count	Frequency (%)
ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	163	28.8%
INDUSTRIA DA CONSTRUCAO	46	8.1%
COMERCIO VAREJISTA	46	8.1%
SERVICOS ADMINISTRATIVOS	42	7.4%
COMERCIO POR ATACADO	40	7.1%
SERVICOS DE EDUCACAO	33	5.8%
QUIMICA-PETROQUIMICA	27	4.8%
SERVICOS DE SAUDE	25	4.4%
TRANSPORTE, ARMAZENAGEM E CORREIO	25	4.4%
COMERCIO E REPARACAO DE VEICULOS	21	3.7%
Other values (19)	98	17.3%

Max length	49
Mean length	30.048
Min length	7
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

de_saude_rescencia
Constant

This variable is constant and should be ignored for analysis

Constant value	ACIMA DE 1 ANO

de_saude_tributaria
Categorical

Distinct count	5
Unique (%)	0.9%
Missing (%)	0.0%
Missing (n)	0

VERDE	376
AZUL	134
LARANJA	44
Other values (2)	12

Toggle details

Common values
Composition

Value	Count	Frequency (%)
VERDE	376	66.4%
AZUL	134	23.7%
LARANJA	44	7.8%
VERMELHO	11	1.9%
AMARELO	1	0.2%

Max length	8
Mean length	4.9806
Min length	4
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

dt_situacao
Categorical

Distinct count	207
Unique (%)	36.6%
Missing (%)	0.0%
Missing (n)	0

2005-11-03	201
2005-08-27	36
2005-09-24	32
Other values (204)	297

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2005-11-03	201	35.5%
2005-08-27	36	6.4%
2005-09-24	32	5.7%
1998-07-28	17	3.0%
2005-10-07	8	1.4%
2005-10-14	6	1.1%
2004-12-24	5	0.9%
2004-12-31	5	0.9%
1999-02-27	4	0.7%
2005-10-22	4	0.7%
Other values (197)	248	43.8%

Max length	10
Mean length	10
Min length	10
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

empsetorcensitariofaixarendapopulacao
Numeric

Distinct count	439
Unique (%)	77.6%
Missing (%)	12.4%
Missing (n)	70
Infinite (%)	0.0%
Infinite (n)	0

Mean	1722.2
Minimum	262.9
Maximum	8467.1
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	262.9
5-th percentile	503.25
Q1	818.41
Median	1215.2
Q3	2257.7
95-th percentile	4802.2
Maximum	8467.1
Range	8204.2
Interquartile range	1439.2

Descriptive statistics

Standard deviation	1349.3
Coef of variation	0.78347
Kurtosis	3.9356
Mean	1722.2
MAD	998.78
Skewness	1.869
Sum	8.5421e+05
Variance	1.8206e+06
Memory size	8.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1157	10	1.8%
2799.8	4	0.7%
2286.1	3	0.5%
984.57	3	0.5%
3321.9	3	0.5%
2317.1	3	0.5%
1333.1	3	0.5%
1723.2	3	0.5%
5054.1	3	0.5%
2679.5	2	0.4%
Other values (428)	459	81.1%
(Missing)	70	12.4%

Minimum 5 values

Value	Count	Frequency (%)
262.9	1	0.2%
297.41	1	0.2%
304.77	1	0.2%
340.39	1	0.2%
346.02	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
8467.1	2	0.4%
6721.6	1	0.2%
6583.6	1	0.2%
6527.2	1	0.2%
6498.2	1	0.2%

faturamento_est_coligados
Numeric

Distinct count	239
Unique (%)	42.2%
Missing (%)	48.2%
Missing (n)	273
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.9549e+08
Minimum	1.2364e+05
Maximum	7.7807e+09
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1.2364e+05
5-th percentile	2.1e+05
Q1	9.3e+05
Median	7.4801e+06
Q3	4.5219e+07
95-th percentile	4.8541e+08
Maximum	7.7807e+09
Range	7.7806e+09
Interquartile range	4.4289e+07

Descriptive statistics

Standard deviation	8.8832e+08
Coef of variation	4.5441
Kurtosis	45.406
Mean	1.9549e+08
MAD	3.1206e+08
Skewness	6.5329
Sum	5.7278e+10
Variance	7.8912e+17
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2.1e+05	32	5.7%
4.2e+05	10	1.8%
6.3e+05	5	0.9%
9.3e+05	5	0.9%
8.4e+05	2	0.4%
3.3364e+05	2	0.4%
1.14e+06	2	0.4%
1.35e+06	2	0.4%
1.2364e+05	2	0.4%
1.1127e+06	2	0.4%
Other values (228)	229	40.5%
(Missing)	273	48.2%

Minimum 5 values

Value	Count	Frequency (%)
1.2364e+05	2	0.4%
1.5455e+05	1	0.2%
1.6485e+05	1	0.2%
1.8546e+05	1	0.2%
2.1e+05	32	5.7%

Maximum 5 values

Value	Count	Frequency (%)
7.7807e+09	1	0.2%
7.5599e+09	1	0.2%
5.9645e+09	1	0.2%
5.223e+09	1	0.2%
4.1484e+09	1	0.2%

faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis

Correlation	0.96717

fl_antt
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

False	474
True	92

Toggle details

Value	Count	Frequency (%)
False	474	83.7%
True	92	16.3%

fl_email
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

False	304
True	262

Toggle details

Value	Count	Frequency (%)
False	304	53.7%
True	262	46.3%

fl_epp
Constant

This variable is constant and should be ignored for analysis

Constant value	False

fl_ltda
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

False	562
True	4

Toggle details

Value	Count	Frequency (%)
False	562	99.3%
True	4	0.7%

fl_matriz
Constant

This variable is constant and should be ignored for analysis

Constant value	True

fl_me
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

False	564
True	2

Toggle details

Value	Count	Frequency (%)
False	564	99.6%
True	2	0.4%

fl_mei
Constant

This variable is constant and should be ignored for analysis

Constant value	False

fl_optante_simei
Constant

This variable is constant and should be ignored for analysis

Constant value	False

fl_optante_simples
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

False	539
True	27

Toggle details

Value	Count	Frequency (%)
False	539	95.2%
True	27	4.8%

fl_passivel_iss
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

True	490
False	76

Toggle details

Value	Count	Frequency (%)
True	490	86.6%
False	76	13.4%

fl_rm
Categorical

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

SIM	307
NAO	259

Toggle details

Common values
Composition

Value	Count	Frequency (%)
SIM	307	54.2%
NAO	259	45.8%

Max length	3
Mean length	3
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

fl_sa
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

False	543
True	23

Toggle details

Value	Count	Frequency (%)
False	543	95.9%
True	23	4.1%

fl_simples_irregular
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

False	565
True	1

Toggle details

Value	Count	Frequency (%)
False	565	99.8%
True	1	0.2%

fl_spa
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

False	539
True	27

Toggle details

Value	Count	Frequency (%)
False	539	95.2%
True	27	4.8%

fl_st_especial
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

False	564
True	2

Toggle details

Value	Count	Frequency (%)
False	564	99.6%
True	2	0.4%

fl_telefone
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

True	307
False	259

Toggle details

Value	Count	Frequency (%)
True	307	54.2%
False	259	45.8%

fl_veiculo
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

True	490
False	76

Toggle details

Value	Count	Frequency (%)
True	490	86.6%
False	76	13.4%

grau_instrucao_macro_analfabeto
Numeric

Distinct count	18
Unique (%)	3.2%
Missing (%)	79.3%
Missing (n)	449
Infinite (%)	0.0%
Infinite (n)	0

Mean	5.1282
Minimum	1
Maximum	135
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	2
Q3	5
95-th percentile	11.2
Maximum	135
Range	134
Interquartile range	4

Descriptive statistics

Standard deviation	14.434
Coef of variation	2.8146
Kurtosis	63.007
Mean	5.1282
MAD	5.1694
Skewness	7.613
Sum	600
Variance	208.34
Memory size	8.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	51	9.0%
2	20	3.5%
3	11	1.9%
6	7	1.2%
4	5	0.9%
10	4	0.7%
7	4	0.7%
9	3	0.5%
5	2	0.4%
11	2	0.4%
Other values (7)	8	1.4%
(Missing)	449	79.3%

Minimum 5 values

Value	Count	Frequency (%)
1	51	9.0%
2	20	3.5%
3	11	1.9%
4	5	0.9%
5	2	0.4%

Maximum 5 values

Value	Count	Frequency (%)
135	1	0.2%
80	1	0.2%
17	1	0.2%
14	1	0.2%
13	1	0.2%

grau_instrucao_macro_desconhecido
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

grau_instrucao_macro_escolaridade_fundamental
Numeric

Distinct count	157
Unique (%)	27.7%
Missing (%)	8.5%
Missing (n)	48
Infinite (%)	0.0%
Infinite (n)	0

Mean	73.212
Minimum	1
Maximum	3378
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
Median	24.5
Q3	64.75
95-th percentile	268.6
Maximum	3378
Range	3377
Interquartile range	56.75

Descriptive statistics

Standard deviation	205.92
Coef of variation	2.8126
Kurtosis	143.02
Mean	73.212
MAD	80.386
Skewness	10.299
Sum	37924
Variance	42403
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	25	4.4%
2	24	4.2%
4	22	3.9%
3	18	3.2%
7	17	3.0%
10	13	2.3%
6	13	2.3%
13	13	2.3%
18	12	2.1%
9	12	2.1%
Other values (146)	349	61.7%
(Missing)	48	8.5%

Minimum 5 values

Value	Count	Frequency (%)
1	25	4.4%
2	24	4.2%
3	18	3.2%
4	22	3.9%
5	8	1.4%

Maximum 5 values

Value	Count	Frequency (%)
3378	1	0.2%
1943	1	0.2%
1041	1	0.2%
971	1	0.2%
794	1	0.2%

grau_instrucao_macro_escolaridade_media
Numeric

Distinct count	268
Unique (%)	47.3%
Missing (%)	0.5%
Missing (n)	3
Infinite (%)	0.0%
Infinite (n)	0

Mean	189.25
Minimum	1
Maximum	10413
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	18
Q1	48
Median	78
Q3	167.5
95-th percentile	547.4
Maximum	10413
Range	10412
Interquartile range	119.5

Descriptive statistics

Standard deviation	538.65
Coef of variation	2.8463
Kurtosis	235.73
Mean	189.25
MAD	184.5
Skewness	13.389
Sum	1.0655e+05
Variance	2.9014e+05
Memory size	8.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
73	8	1.4%
51	8	1.4%
38	8	1.4%
70	7	1.2%
55	7	1.2%
53	7	1.2%
72	7	1.2%
59	7	1.2%
43	7	1.2%
30	6	1.1%
Other values (257)	491	86.7%

Minimum 5 values

Value	Count	Frequency (%)
1	1	0.2%
3	1	0.2%
4	1	0.2%
5	2	0.4%
6	2	0.4%

Maximum 5 values

Value	Count	Frequency (%)
10413	1	0.2%
3256	1	0.2%
3054	1	0.2%
2447	1	0.2%
2387	1	0.2%

grau_instrucao_macro_escolaridade_superior
Numeric

Distinct count	188
Unique (%)	33.2%
Missing (%)	3.0%
Missing (n)	17
Infinite (%)	0.0%
Infinite (n)	0

Mean	115.98
Minimum	1
Maximum	4791
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
Median	25
Q3	85
95-th percentile	381.6
Maximum	4791
Range	4790
Interquartile range	77

Descriptive statistics

Standard deviation	374.66
Coef of variation	3.2304
Kurtosis	79.781
Mean	115.98
MAD	140.54
Skewness	8.1075
Sum	63674
Variance	1.4037e+05
Memory size	8.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3	30	5.3%
2	27	4.8%
4	18	3.2%
7	17	3.0%
5	16	2.8%
1	15	2.7%
6	14	2.5%
10	12	2.1%
8	12	2.1%
12	11	1.9%
Other values (177)	377	66.6%
(Missing)	17	3.0%

Minimum 5 values

Value	Count	Frequency (%)
1	15	2.7%
2	27	4.8%
3	30	5.3%
4	18	3.2%
5	16	2.8%

Maximum 5 values

Value	Count	Frequency (%)
4791	1	0.2%
4152	1	0.2%
2807	1	0.2%
2652	1	0.2%
2161	1	0.2%

id
Categorical, Unique

First 5 values
00990ce9e5ed028c985c70d79caf6bfafec0611deacee65001879ae201e5d36b
01a586fca9efeab9f83ccab019962b0887882fac2625fe8363da97276c25e0f2
01ecafa00e8e543ab9fe828672c4c1ff5737610514c0b8e33b0a49a83f72238c
021ac088e5a7462494d919e7b7b0781e9ae5aa8b6a370b2d65c44345f0ecc857
021d2faf177f995a2011eb905d14777ec5091106b121a4bdb7f4a6eac5fd978f

Last 5 values
ff4ce2406e71e486b19e95137147273a32f8dd218a78d7a5ea0952f135258ef9
ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3ff71d663ecf8761bc6
ff7a936c109aa9eacb07b9a4817b6358b41221644c2bce37ba76d16469a8982a
ffa23f42a6e5d386c5af84a747bdc32d43e632b6ffaaac3ac349c280cae803fd
ffeeb8d2494392dc868d636243d3f97ab607b9ca6e200aa897cbd7cb320cf8a2

Toggle details

First 5 values

Value	Count	Frequency (%)
00990ce9e5ed028c985c70d79caf6bfafec0611deacee65001879ae201e5d36b	1	0.2%
01a586fca9efeab9f83ccab019962b0887882fac2625fe8363da97276c25e0f2	1	0.2%
01ecafa00e8e543ab9fe828672c4c1ff5737610514c0b8e33b0a49a83f72238c	1	0.2%
021ac088e5a7462494d919e7b7b0781e9ae5aa8b6a370b2d65c44345f0ecc857	1	0.2%
021d2faf177f995a2011eb905d14777ec5091106b121a4bdb7f4a6eac5fd978f	1	0.2%

Last 5 values

Value	Count	Frequency (%)
ffeeb8d2494392dc868d636243d3f97ab607b9ca6e200aa897cbd7cb320cf8a2	1	0.2%
ffa23f42a6e5d386c5af84a747bdc32d43e632b6ffaaac3ac349c280cae803fd	1	0.2%
ff7a936c109aa9eacb07b9a4817b6358b41221644c2bce37ba76d16469a8982a	1	0.2%
ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3ff71d663ecf8761bc6	1	0.2%
ff4ce2406e71e486b19e95137147273a32f8dd218a78d7a5ea0952f135258ef9	1	0.2%

idade_acima_de_58
Numeric

Distinct count	100
Unique (%)	17.7%
Missing (%)	10.8%
Missing (n)	61
Infinite (%)	0.0%
Infinite (n)	0

Mean	40.749
Minimum	1
Maximum	3663
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
Median	8
Q3	23
95-th percentile	117
Maximum	3663
Range	3662
Interquartile range	20

Descriptive statistics

Standard deviation	203.01
Coef of variation	4.982
Kurtosis	218.01
Mean	40.749
MAD	52.517
Skewness	13.587
Sum	20578
Variance	41213
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	55	9.7%
1	55	9.7%
5	38	6.7%
3	32	5.7%
4	31	5.5%
7	21	3.7%
6	20	3.5%
8	17	3.0%
9	14	2.5%
11	13	2.3%
Other values (89)	209	36.9%
(Missing)	61	10.8%

Minimum 5 values

Value	Count	Frequency (%)
1	55	9.7%
2	55	9.7%
3	32	5.7%
4	31	5.5%
5	38	6.7%

Maximum 5 values

Value	Count	Frequency (%)
3663	1	0.2%
1844	1	0.2%
1401	1	0.2%
906	1	0.2%
674	1	0.2%

idade_ate_18
Numeric

Distinct count	15
Unique (%)	2.7%
Missing (%)	62.0%
Missing (n)	351
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.4558
Minimum	1
Maximum	83
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	2
Q3	3.5
95-th percentile	7
Maximum	83
Range	82
Interquartile range	2.5

Descriptive statistics

Standard deviation	7.1615
Coef of variation	2.0723
Kurtosis	85.449
Mean	3.4558
MAD	2.6082
Skewness	8.6671
Sum	743
Variance	51.287
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	78	13.8%
2	51	9.0%
3	32	5.7%
4	14	2.5%
6	13	2.3%
5	11	1.9%
7	6	1.1%
8	3	0.5%
9	2	0.4%
10	1	0.2%
Other values (4)	4	0.7%
(Missing)	351	62.0%

Minimum 5 values

Value	Count	Frequency (%)
1	78	13.8%
2	51	9.0%
3	32	5.7%
4	14	2.5%
5	11	1.9%

Maximum 5 values

Value	Count	Frequency (%)
83	1	0.2%
56	1	0.2%
33	1	0.2%
12	1	0.2%
10	1	0.2%

idade_de_19_a_23
Numeric

Distinct count	72
Unique (%)	12.7%
Missing (%)	16.6%
Missing (n)	94
Infinite (%)	0.0%
Infinite (n)	0

Mean	18.307
Minimum	1
Maximum	643
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
Median	9
Q3	16.25
95-th percentile	56.45
Maximum	643
Range	642
Interquartile range	13.25

Descriptive statistics

Standard deviation	45.5
Coef of variation	2.4854
Kurtosis	91.846
Mean	18.307
MAD	17.735
Skewness	8.433
Sum	8641
Variance	2070.3
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	52	9.2%
2	38	6.7%
3	35	6.2%
4	25	4.4%
5	25	4.4%
8	24	4.2%
9	21	3.7%
11	20	3.5%
6	20	3.5%
10	17	3.0%
Other values (61)	195	34.5%
(Missing)	94	16.6%

Minimum 5 values

Value	Count	Frequency (%)
1	52	9.2%
2	38	6.7%
3	35	6.2%
4	25	4.4%
5	25	4.4%

Maximum 5 values

Value	Count	Frequency (%)
643	1	0.2%
373	1	0.2%
323	1	0.2%
286	1	0.2%
253	1	0.2%

idade_de_24_a_28
Numeric

Distinct count	107
Unique (%)	18.9%
Missing (%)	3.0%
Missing (n)	17
Infinite (%)	0.0%
Infinite (n)	0

Mean	33.137
Minimum	1
Maximum	949
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	3
Q1	9
Median	17
Q3	31
95-th percentile	101.8
Maximum	949
Range	948
Interquartile range	22

Descriptive statistics

Standard deviation	66.397
Coef of variation	2.0037
Kurtosis	83.925
Mean	33.137
MAD	29.786
Skewness	7.76
Sum	18192
Variance	4408.6
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
6	25	4.4%
12	22	3.9%
9	21	3.7%
7	20	3.5%
8	20	3.5%
15	20	3.5%
10	19	3.4%
21	19	3.4%
11	19	3.4%
17	17	3.0%
Other values (96)	347	61.3%

Minimum 5 values

Value	Count	Frequency (%)
1	11	1.9%
2	11	1.9%
3	15	2.7%
4	16	2.8%
5	13	2.3%

Maximum 5 values

Value	Count	Frequency (%)
949	1	0.2%
631	1	0.2%
486	1	0.2%
376	1	0.2%
359	1	0.2%

idade_de_29_a_33
Numeric

Distinct count	136
Unique (%)	24.0%
Missing (%)	0.7%
Missing (n)	4
Infinite (%)	0.0%
Infinite (n)	0

Mean	49.623
Minimum	1
Maximum	785
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	7.05
Q1	14
Median	23
Q3	45
95-th percentile	169.8
Maximum	785
Range	784
Interquartile range	31

Descriptive statistics

Standard deviation	87.526
Coef of variation	1.7638
Kurtosis	30.979
Mean	49.623
MAD	44.244
Skewness	5.0723
Sum	27888
Variance	7660.8
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
16	24	4.2%
9	22	3.9%
12	21	3.7%
15	21	3.7%
18	20	3.5%
13	19	3.4%
10	19	3.4%
19	17	3.0%
26	15	2.7%
8	15	2.7%
Other values (125)	369	65.2%

Minimum 5 values

Value	Count	Frequency (%)
1	1	0.2%
2	4	0.7%
3	3	0.5%
4	5	0.9%
5	4	0.7%

Maximum 5 values

Value	Count	Frequency (%)
785	1	0.2%
749	1	0.2%
714	1	0.2%
580	1	0.2%
559	1	0.2%

idade_de_34_a_38
Numeric

Distinct count	148
Unique (%)	26.1%
Missing (%)	0.2%
Missing (n)	1
Infinite (%)	0.0%
Infinite (n)	0

Mean	59.08
Minimum	1
Maximum	1884
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	8
Q1	15
Median	25
Q3	49
95-th percentile	178.4
Maximum	1884
Range	1883
Interquartile range	34

Descriptive statistics

Standard deviation	128.65
Coef of variation	2.1775
Kurtosis	87.798
Mean	59.08
MAD	56.537
Skewness	7.9617
Sum	33380
Variance	16550
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
16	20	3.5%
13	19	3.4%
11	19	3.4%
21	18	3.2%
14	18	3.2%
10	17	3.0%
20	15	2.7%
17	15	2.7%
22	14	2.5%
12	14	2.5%
Other values (137)	396	70.0%

Minimum 5 values

Value	Count	Frequency (%)
1	2	0.4%
3	5	0.9%
4	1	0.2%
5	5	0.9%
6	8	1.4%

Maximum 5 values

Value	Count	Frequency (%)
1884	1	0.2%
1047	1	0.2%
1027	1	0.2%
923	1	0.2%
620	1	0.2%

idade_de_39_a_43
Highly correlated

This variable is highly correlated with idade_de_34_a_38 and should be ignored for analysis

Correlation	0.95905

idade_de_44_a_48
Highly correlated

This variable is highly correlated with idade_de_39_a_43 and should be ignored for analysis

Correlation	0.98342

idade_de_49_a_53
Highly correlated

This variable is highly correlated with idade_de_44_a_48 and should be ignored for analysis

Correlation	0.99027

idade_de_54_a_58
Highly correlated

This variable is highly correlated with idade_de_49_a_53 and should be ignored for analysis

Correlation	0.98514

idade_emp_cat
Categorical

Distinct count	3
Unique (%)	0.5%
Missing (%)	0.0%
Missing (n)	0

> 20	379
10 a 15	98
15 a 20	89

Toggle details

Common values
Composition

Value	Count	Frequency (%)
> 20	379	67.0%
10 a 15	98	17.3%
15 a 20	89	15.7%

Max length	7
Mean length	4.9912
Min length	4
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

idade_empresa_anos
Numeric

Distinct count	486
Unique (%)	85.9%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	26.988
Minimum	10.038
Maximum	55.126
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	10.038
5-th percentile	11.737
Q1	17.832
Median	23.403
Q3	38.628
95-th percentile	45.099
Maximum	55.126
Range	45.088
Interquartile range	20.796

Descriptive statistics

Standard deviation	11.638
Coef of variation	0.43125
Kurtosis	-1.0421
Mean	26.988
MAD	10.014
Skewness	0.4655
Sum	15275
Variance	135.45
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[10.03835616 21.81506849 21.85342466 26.79178082 43.76575342 43.85342466 43.85616438 43.88219178 52.20547945 55.1260274 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
21.836	16	2.8%
43.855	14	2.5%
43.866	10	1.8%
21.833	7	1.2%
43.877	6	1.1%
43.868	5	0.9%
43.8	3	0.5%
21.816	3	0.5%
26.362	2	0.4%
18.512	2	0.4%
Other values (476)	498	88.0%

Minimum 5 values

Value	Count	Frequency (%)
10.038	1	0.2%
10.066	1	0.2%
10.285	1	0.2%
10.323	1	0.2%
10.364	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
55.126	1	0.2%
52.274	1	0.2%
52.137	1	0.2%
52.036	1	0.2%
51.852	1	0.2%

idade_maxima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_antiga_ativa and should be ignored for analysis

Correlation	0.99911

idade_maxima_socios
Numeric

Distinct count	62
Unique (%)	11.0%
Missing (%)	37.6%
Missing (n)	213
Infinite (%)	0.0%
Infinite (n)	0

Mean	57.609
Minimum	20
Maximum	90
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	20
5-th percentile	35.6
Q1	49
Median	59
Q3	66
95-th percentile	78
Maximum	90
Range	70
Interquartile range	17

Descriptive statistics

Standard deviation	12.817
Coef of variation	0.22249
Kurtosis	-0.24842
Mean	57.609
MAD	10.337
Skewness	-0.048472
Sum	20336
Variance	164.28
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
59	17	3.0%
61	16	2.8%
52	14	2.5%
57	13	2.3%
65	12	2.1%
54	12	2.1%
64	12	2.1%
55	12	2.1%
68	11	1.9%
66	10	1.8%
Other values (51)	224	39.6%
(Missing)	213	37.6%

Minimum 5 values

Value	Count	Frequency (%)
20	1	0.2%
28	1	0.2%
29	1	0.2%
30	2	0.4%
31	3	0.5%

Maximum 5 values

Value	Count	Frequency (%)
90	3	0.5%
89	1	0.2%
86	1	0.2%
84	2	0.4%
83	2	0.4%

idade_media_coligadas
Numeric

Distinct count	300
Unique (%)	53.0%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	174.32
Minimum	2.7667
Maximum	615.18
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2.7667
5-th percentile	35.37
Q1	98.146
Median	156.06
Q3	234.78
95-th percentile	367.69
Maximum	615.18
Range	612.42
Interquartile range	136.63

Descriptive statistics

Standard deviation	105.31
Coef of variation	0.60415
Kurtosis	1.0267
Mean	174.32
MAD	83.184
Skewness	0.92416
Sum	52121
Variance	11091
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
82.72	1	0.2%
194.17	1	0.2%
247.94	1	0.2%
128.69	1	0.2%
191.47	1	0.2%
245.22	1	0.2%
75.467	1	0.2%
189	1	0.2%
71.462	1	0.2%
161.37	1	0.2%
Other values (289)	289	51.1%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
2.7667	1	0.2%
5.8	1	0.2%
8.9333	1	0.2%
9.4667	1	0.2%
13.65	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
615.18	1	0.2%
504.69	1	0.2%
495.95	1	0.2%
488.5	1	0.2%
444.53	1	0.2%

idade_media_coligadas_ativas
Highly correlated

This variable is highly correlated with idade_media_coligadas and should be ignored for analysis

Correlation	0.9995

idade_media_coligadas_baixadas
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

idade_media_socios
Numeric

Distinct count	144
Unique (%)	25.4%
Missing (%)	37.6%
Missing (n)	213
Infinite (%)	0.0%
Infinite (n)	0

Mean	51.557
Minimum	20
Maximum	90
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	20
5-th percentile	33.5
Q1	44
Median	51.5
Q3	58.5
95-th percentile	69.4
Maximum	90
Range	70
Interquartile range	14.5

Descriptive statistics

Standard deviation	11.068
Coef of variation	0.21468
Kurtosis	0.3014
Mean	51.557
MAD	8.7733
Skewness	0.24258
Sum	18199
Variance	122.5
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
52	11	1.9%
47	9	1.6%
54	8	1.4%
46	8	1.4%
43.5	8	1.4%
50	8	1.4%
59	7	1.2%
56.5	7	1.2%
56	7	1.2%
44	7	1.2%
Other values (133)	273	48.2%
(Missing)	213	37.6%

Minimum 5 values

Value	Count	Frequency (%)
20	1	0.2%
27	2	0.4%
28	1	0.2%
29	1	0.2%
29.5	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
90	2	0.4%
80.143	1	0.2%
79	2	0.4%
78	1	0.2%
76.5	1	0.2%

idade_minima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_nova_ativa and should be ignored for analysis

Correlation	0.99963

idade_minima_socios
Numeric

Distinct count	62
Unique (%)	11.0%
Missing (%)	37.6%
Missing (n)	213
Infinite (%)	0.0%
Infinite (n)	0

Mean	46.028
Minimum	12
Maximum	90
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	12
5-th percentile	25.6
Q1	36
Median	46
Q3	55
95-th percentile	68
Maximum	90
Range	78
Interquartile range	19

Descriptive statistics

Standard deviation	13.071
Coef of variation	0.28398
Kurtosis	-0.077736
Mean	46.028
MAD	10.693
Skewness	0.27433
Sum	16248
Variance	170.86
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
54	14	2.5%
34	13	2.3%
52	13	2.3%
36	12	2.1%
46	12	2.1%
57	12	2.1%
41	11	1.9%
39	11	1.9%
35	11	1.9%
50	11	1.9%
Other values (51)	233	41.2%
(Missing)	213	37.6%

Minimum 5 values

Value	Count	Frequency (%)
12	1	0.2%
19	1	0.2%
20	1	0.2%
21	2	0.4%
22	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
90	2	0.4%
79	1	0.2%
78	1	0.2%
76	2	0.4%
75	1	0.2%

max_faturamento_est_coligados
Numeric

Distinct count	200
Unique (%)	35.3%
Missing (%)	48.2%
Missing (n)	273
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.1648e+08
Minimum	1.2364e+05
Maximum	5.9628e+09
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1.2364e+05
5-th percentile	2.1e+05
Q1	7.4183e+05
Median	5.4401e+06
Q3	2.9982e+07
95-th percentile	2.3008e+08
Maximum	5.9628e+09
Range	5.9627e+09
Interquartile range	2.924e+07

Descriptive statistics

Standard deviation	5.782e+08
Coef of variation	4.9639
Kurtosis	62.629
Mean	1.1648e+08
MAD	1.8406e+08
Skewness	7.5526
Sum	3.4129e+10
Variance	3.3431e+17
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2.1e+05	52	9.2%
9.3e+05	16	2.8%
7.4183e+05	4	0.7%
1.1127e+06	4	0.7%
3.7092e+05	3	0.5%
2.8437e+06	2	0.4%
9.8911e+05	2	0.4%
1.7412e+07	2	0.4%
1.2364e+06	2	0.4%
4.451e+07	2	0.4%
Other values (189)	204	36.0%
(Missing)	273	48.2%

Minimum 5 values

Value	Count	Frequency (%)
1.2364e+05	2	0.4%
1.5455e+05	1	0.2%
1.6485e+05	1	0.2%
1.8546e+05	1	0.2%
2.1e+05	52	9.2%

Maximum 5 values

Value	Count	Frequency (%)
5.9628e+09	1	0.2%
5.151e+09	1	0.2%
3.7745e+09	1	0.2%
2.9397e+09	1	0.2%
2.1245e+09	1	0.2%

max_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation	0.94873

max_filiais_coligados
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados_gp and should be ignored for analysis

Correlation	0.92095

max_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with max_filiais_coligados and should be ignored for analysis

Correlation	0.95968

max_meses_servicos
Numeric

Distinct count	447
Unique (%)	79.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	339.44
Minimum	7.6
Maximum	5099.1
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	7.6
5-th percentile	84.825
Q1	156.07
Median	256.02
Q3	438.92
95-th percentile	584.43
Maximum	5099.1
Range	5091.5
Interquartile range	282.85

Descriptive statistics

Standard deviation	519.33
Coef of variation	1.53
Kurtosis	72.727
Mean	339.44
MAD	200.36
Skewness	8.1902
Sum	1.9212e+05
Variance	2.6971e+05
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 7.6 91.65 95.75 253.3 253.53333333 ... 506.21666667 507.45 594.36666667 722.3 5099.06666667], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
265.63	7	1.2%
5099.1	6	1.1%
265.67	5	0.9%
470.67	5	0.9%
253.47	5	0.9%
507.2	5	0.9%
236.3	4	0.7%
545.7	4	0.7%
92.233	4	0.7%
201.8	4	0.7%
Other values (437)	517	91.3%

Minimum 5 values

Value	Count	Frequency (%)
7.6	1	0.2%
21.133	1	0.2%
24.2	1	0.2%
29.6	1	0.2%
30.333	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
5099.1	6	1.1%
727	1	0.2%
717.6	1	0.2%
707.37	1	0.2%
706	1	0.2%

max_meses_servicos_all
Numeric

Distinct count	383
Unique (%)	67.7%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1420.1
Minimum	7.6
Maximum	5099.1
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	7.6
5-th percentile	94.125
Q1	176.38
Median	284.05
Q3	626.35
95-th percentile	5039.3
Maximum	5099.1
Range	5091.5
Interquartile range	449.97

Descriptive statistics

Standard deviation	2053.6
Coef of variation	1.4461
Kurtosis	-0.5809
Mean	1420.1
MAD	1758.9
Skewness	1.1844
Sum	8.0376e+05
Variance	4.2172e+06
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 7.6 91.65 253.3 253.53333333 267.68333333 ... 550.73333333 707.61666667 5008.88333333 5021.06666667 5099.06666667], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
5015	102	18.0%
5064.7	18	3.2%
5099.1	6	1.1%
5039.3	5	0.9%
5027.2	4	0.7%
201.8	4	0.7%
265.63	4	0.7%
253.47	3	0.5%
254.53	3	0.5%
168.2	3	0.5%
Other values (373)	414	73.1%

Minimum 5 values

Value	Count	Frequency (%)
7.6	1	0.2%
21.2	1	0.2%
24.2	1	0.2%
29.6	1	0.2%
38.433	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
5099.1	6	1.1%
5065.7	2	0.4%
5064.7	18	3.2%
5039.3	5	0.9%
5027.2	4	0.7%

max_vl_folha_coligados
Numeric

Distinct count	188
Unique (%)	33.2%
Missing (%)	58.7%
Missing (n)	332
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.7944e+07
Minimum	61819
Maximum	3.5404e+08
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	61819
5-th percentile	1.2364e+05
Q1	8.8608e+05
Median	4.0492e+06
Q3	1.223e+07
95-th percentile	8.0761e+07
Maximum	3.5404e+08
Range	3.5398e+08
Interquartile range	1.1344e+07

Descriptive statistics

Standard deviation	4.5464e+07
Coef of variation	2.5336
Kurtosis	25.193
Mean	1.7944e+07
MAD	2.2338e+07
Skewness	4.7056
Sum	4.1989e+09
Variance	2.067e+15
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
61819	9	1.6%
2.4728e+05	5	0.9%
5.5637e+05	4	0.7%
1.2364e+05	3	0.5%
3.7092e+05	3	0.5%
1.4424e+05	3	0.5%
1.257e+06	3	0.5%
6.1819e+05	3	0.5%
1.8546e+05	3	0.5%
1.6959e+07	2	0.4%
Other values (177)	196	34.6%
(Missing)	332	58.7%

Minimum 5 values

Value	Count	Frequency (%)
61819	9	1.6%
82426	1	0.2%
1.0303e+05	1	0.2%
1.2364e+05	3	0.5%
1.4424e+05	3	0.5%

Maximum 5 values

Value	Count	Frequency (%)
3.5404e+08	1	0.2%
3.1303e+08	1	0.2%
2.4398e+08	1	0.2%
2.0771e+08	1	0.2%
2.0392e+08	1	0.2%

max_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados_gp and should be ignored for analysis

Correlation	0.9326

media_faturamento_est_coligados
Numeric

Distinct count	237
Unique (%)	41.9%
Missing (%)	48.2%
Missing (n)	273
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.6857e+07
Minimum	1.2364e+05
Maximum	1.1929e+09
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1.2364e+05
5-th percentile	2.1e+05
Q1	3.8319e+05
Median	1.9905e+06
Q3	7.8792e+06
95-th percentile	4.2989e+07
Maximum	1.1929e+09
Range	1.1928e+09
Interquartile range	7.496e+06

Descriptive statistics

Standard deviation	8.2355e+07
Coef of variation	4.8856
Kurtosis	148.75
Mean	1.6857e+07
MAD	2.3582e+07
Skewness	11.271
Sum	4.939e+09
Variance	6.7823e+15
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2.1e+05	49	8.7%
9.3e+05	5	0.9%
1.2364e+05	2	0.4%
1.1127e+06	2	0.4%
1.6682e+05	2	0.4%
4.5e+05	2	0.4%
5.7e+05	2	0.4%
7.4183e+05	1	0.2%
3.1796e+06	1	0.2%
3.1584e+06	1	0.2%
Other values (226)	226	39.9%
(Missing)	273	48.2%

Minimum 5 values

Value	Count	Frequency (%)
1.2364e+05	2	0.4%
1.5455e+05	1	0.2%
1.6485e+05	1	0.2%
1.6682e+05	2	0.4%
1.8121e+05	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
1.1929e+09	1	0.2%
5.1855e+08	1	0.2%
3.482e+08	1	0.2%
3.04e+08	1	0.2%
2.1e+08	1	0.2%

media_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados and should be ignored for analysis

Correlation	0.97553

media_filiais_coligados
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis

Correlation	0.93788

media_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with media_filiais_coligados and should be ignored for analysis

Correlation	0.97637

media_meses_servicos
Numeric

Distinct count	566
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	94.173
Minimum	5.5541
Maximum	459.97
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	5.5541
5-th percentile	24.093
Q1	43.726
Median	69.796
Q3	146.37
95-th percentile	211.79
Maximum	459.97
Range	454.41
Interquartile range	102.64

Descriptive statistics

Standard deviation	67.051
Coef of variation	0.71199
Kurtosis	2.2185
Mean	94.173
MAD	54.899
Skewness	1.281
Sum	53302
Variance	4495.8
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 5.5541387 23.48033312 57.21315789 81.80277904 200.91285363 247.56763822 459.96901121], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
44.588	1	0.2%
223.04	1	0.2%
64.525	1	0.2%
167.65	1	0.2%
12.775	1	0.2%
24.963	1	0.2%
47.901	1	0.2%
163.25	1	0.2%
70.287	1	0.2%
142.8	1	0.2%
Other values (556)	556	98.2%

Minimum 5 values

Value	Count	Frequency (%)
5.5541	1	0.2%
5.6098	1	0.2%
7.5586	1	0.2%
7.8968	1	0.2%
8.4043	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
459.97	1	0.2%
409.3	1	0.2%
353.95	1	0.2%
319.02	1	0.2%
313.49	1	0.2%

media_meses_servicos_all
Numeric

Distinct count	566
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	80.261
Minimum	2.7073
Maximum	944.63
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2.7073
5-th percentile	12.328
Q1	24.679
Median	43.504
Q3	113.48
95-th percentile	241.55
Maximum	944.63
Range	941.93
Interquartile range	88.8

Descriptive statistics

Standard deviation	88.567
Coef of variation	1.1035
Kurtosis	18.79
Mean	80.261
MAD	62.934
Skewness	3.1463
Sum	45428
Variance	7844.1
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 2.70732436 10.45628531 37.64888255 64.36235372 173.7754826 249.26943319 364.54312211 944.63353181], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
41.333	1	0.2%
99.279	1	0.2%
51.131	1	0.2%
27.848	1	0.2%
29.978	1	0.2%
29.744	1	0.2%
55.641	1	0.2%
73.271	1	0.2%
30.596	1	0.2%
11.399	1	0.2%
Other values (556)	556	98.2%

Minimum 5 values

Value	Count	Frequency (%)
2.7073	1	0.2%
6.9806	1	0.2%
6.9941	1	0.2%
7.1839	1	0.2%
8.1179	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
944.63	1	0.2%
533.92	1	0.2%
519.21	1	0.2%
452.33	1	0.2%
430.08	1	0.2%

media_vl_folha_coligados
Numeric

Distinct count	213
Unique (%)	37.6%
Missing (%)	58.7%
Missing (n)	332
Infinite (%)	0.0%
Infinite (n)	0

Mean	7.12e+06
Minimum	61819
Maximum	3.5404e+08
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	61819
5-th percentile	1.1643e+05
Q1	6.1819e+05
Median	2.1194e+06
Q3	5.3963e+06
95-th percentile	2.1135e+07
Maximum	3.5404e+08
Range	3.5398e+08
Interquartile range	4.7781e+06

Descriptive statistics

Standard deviation	2.6367e+07
Coef of variation	3.7032
Kurtosis	132.71
Mean	7.12e+06
MAD	8.2936e+06
Skewness	10.705
Sum	1.6661e+09
Variance	6.952e+14
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
61819	9	1.6%
6.1819e+05	3	0.5%
2.4728e+05	3	0.5%
1.4424e+05	3	0.5%
1.8546e+05	3	0.5%
5.5637e+05	2	0.4%
6.8001e+05	2	0.4%
1.6485e+05	2	0.4%
1.257e+06	2	0.4%
1.2364e+05	2	0.4%
Other values (202)	203	35.9%
(Missing)	332	58.7%

Minimum 5 values

Value	Count	Frequency (%)
61819	9	1.6%
82426	1	0.2%
92729	1	0.2%
1.0303e+05	1	0.2%
1.2364e+05	2	0.4%

Maximum 5 values

Value	Count	Frequency (%)
3.5404e+08	1	0.2%
1.2942e+08	1	0.2%
1.2343e+08	1	0.2%
4.8631e+07	1	0.2%
4.0188e+07	1	0.2%

media_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis

Correlation	0.93982

meses_ultima_contratacaco
Numeric

Distinct count	212
Unique (%)	37.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	13.003
Minimum	1.9333
Maximum	405.73
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1.9333
5-th percentile	2.0333
Q1	2.4417
Median	3.9333
Q3	23.95
95-th percentile	34.367
Maximum	405.73
Range	403.8
Interquartile range	21.508

Descriptive statistics

Standard deviation	21.492
Coef of variation	1.6528
Kurtosis	197.63
Mean	13.003
MAD	12.468
Skewness	11.233
Sum	7359.7
Variance	461.9
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 1.93333333 2.28333333 2.31666667 2.91666667 2.96666667 ... 28.31666667 34.3 34.38333333 64.5 405.73333333], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2.9333	37	6.5%
2.3	32	5.7%
23.2	18	3.2%
2	16	2.8%
2.0667	16	2.8%
2.2667	16	2.8%
2.5333	13	2.3%
3.9333	12	2.1%
2.7667	12	2.1%
2.2	12	2.1%
Other values (202)	382	67.5%

Minimum 5 values

Value	Count	Frequency (%)
1.9333	1	0.2%
1.9667	4	0.7%
2	16	2.8%
2.0333	12	2.1%
2.0667	16	2.8%

Maximum 5 values

Value	Count	Frequency (%)
405.73	1	0.2%
106.37	1	0.2%
65.833	1	0.2%
63.167	1	0.2%
62.833	1	0.2%

min_faturamento_est_coligados
Numeric

Distinct count	61
Unique (%)	10.8%
Missing (%)	48.2%
Missing (n)	273
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.1133e+06
Minimum	0
Maximum	6.0995e+07
Zeros (%)	0.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	79429
Q1	2.1e+05
Median	2.1e+05
Q3	2.1e+05
95-th percentile	3.8843e+06
Maximum	6.0995e+07
Range	6.0995e+07
Interquartile range	0

Descriptive statistics

Standard deviation	4.7212e+06
Coef of variation	4.2405
Kurtosis	99.342
Mean	1.1133e+06
MAD	1.5638e+06
Skewness	9.1002
Sum	3.2621e+08
Variance	2.229e+13
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2.1e+05	173	30.6%
1.2364e+05	26	4.6%
1.8546e+05	7	1.2%
41213	6	1.1%
9.3e+05	6	1.1%
2.0606e+05	4	0.7%
1.5455e+05	3	0.5%
82426	3	0.5%
74933	2	0.4%
6.1819e+05	2	0.4%
Other values (50)	61	10.8%
(Missing)	273	48.2%

Minimum 5 values

Value	Count	Frequency (%)
0	1	0.2%
9141	1	0.2%
19079	1	0.2%
41213	6	1.1%
50000	2	0.4%

Maximum 5 values

Value	Count	Frequency (%)
6.0995e+07	1	0.2%
3.3794e+07	1	0.2%
2.3182e+07	1	0.2%
2.1328e+07	1	0.2%
2.0091e+07	1	0.2%

min_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with min_faturamento_est_coligados and should be ignored for analysis

Correlation	0.94763

min_filiais_coligados
Numeric

Distinct count	10
Unique (%)	1.8%
Missing (%)	73.0%
Missing (n)	413
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.719
Minimum	1
Maximum	33
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	1
Q3	1
95-th percentile	5
Maximum	33
Range	32
Interquartile range	0

Descriptive statistics

Standard deviation	2.8573
Coef of variation	1.6622
Kurtosis	95.774
Mean	1.719
MAD	1.1184
Skewness	9.0067
Sum	263
Variance	8.1639
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	119	21.0%
2	17	3.0%
3	5	0.9%
5	3	0.5%
4	3	0.5%
8	2	0.4%
6	2	0.4%
7	1	0.2%
33	1	0.2%
(Missing)	413	73.0%

Minimum 5 values

Value	Count	Frequency (%)
1	119	21.0%
2	17	3.0%
3	5	0.9%
4	3	0.5%
5	3	0.5%

Maximum 5 values

Value	Count	Frequency (%)
33	1	0.2%
8	2	0.4%
7	1	0.2%
6	2	0.4%
5	3	0.5%

min_funcionarios_coligados_gp
Numeric

Distinct count	59
Unique (%)	10.4%
Missing (%)	55.5%
Missing (n)	314
Infinite (%)	0.0%
Infinite (n)	0

Mean	27.286
Minimum	0
Maximum	2112
Zeros (%)	16.4%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	1.5
Q3	10
95-th percentile	100.25
Maximum	2112
Range	2112
Interquartile range	10

Descriptive statistics

Standard deviation	143.46
Coef of variation	5.2578
Kurtosis	180.08
Mean	27.286
MAD	40.739
Skewness	12.67
Sum	6876
Variance	20582
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	93	16.4%
1	33	5.8%
2	16	2.8%
3	14	2.5%
4	8	1.4%
5	7	1.2%
7	6	1.1%
10	6	1.1%
9	5	0.9%
6	5	0.9%
Other values (48)	59	10.4%
(Missing)	314	55.5%

Minimum 5 values

Value	Count	Frequency (%)
0	93	16.4%
1	33	5.8%
2	16	2.8%
3	14	2.5%
4	8	1.4%

Maximum 5 values

Value	Count	Frequency (%)
2112	1	0.2%
592	1	0.2%
360	1	0.2%
257	1	0.2%
235	1	0.2%

min_meses_servicos
Highly correlated

This variable is highly correlated with meses_ultima_contratacaco and should be ignored for analysis

Correlation	0.98348

min_meses_servicos_all
Numeric

Distinct count	152
Unique (%)	26.9%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.84376
Minimum	-12.033
Maximum	266.17
Zeros (%)	6.2%

Toggle details

Quantile statistics

Minimum	-12.033
5-th percentile	-6.1
Q1	-0.63333
Median	-0.26667
Q3	0.4
95-th percentile	8.1333
Maximum	266.17
Range	278.2
Interquartile range	1.0333

Descriptive statistics

Standard deviation	12.152
Coef of variation	14.402
Kurtosis	403.93
Mean	0.84376
MAD	3.0247
Skewness	18.649
Sum	477.57
Variance	147.68
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[-1.20333333e+01 -1.05000000e+00 -8.16666667e-01 -3.16666667e-01 -5.00000000e-02 ... 2.98333333e+00 3.10000000e+00 1.20666667e+01 3.48666667e+01 2.66166667e+02], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	35	6.2%
-0.033333	30	5.3%
-0.63333	24	4.2%
-0.5	23	4.1%
-0.7	18	3.2%
-0.36667	16	2.8%
-0.43333	14	2.5%
-0.56667	13	2.3%
1	13	2.3%
-0.33333	12	2.1%
Other values (142)	368	65.0%

Minimum 5 values

Value	Count	Frequency (%)
-12.033	1	0.2%
-11.9	1	0.2%
-11.667	1	0.2%
-11.2	3	0.5%
-11.167	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
266.17	1	0.2%
35.4	1	0.2%
34.333	1	0.2%
27.5	1	0.2%
27.267	1	0.2%

min_vl_folha_coligados
Highly correlated

This variable is highly correlated with media_vl_folha_coligados and should be ignored for analysis

Correlation	0.92717

min_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with min_vl_folha_coligados and should be ignored for analysis

Correlation	0.95645

natureza_juridica_macro
Categorical

Distinct count	4
Unique (%)	0.7%
Missing (%)	0.0%
Missing (n)	0

ENTIDADES EMPRESARIAIS	323
OUTROS	152
ADMINISTRACAO PUBLICA	56

Toggle details

Common values
Composition

Value	Count	Frequency (%)
ENTIDADES EMPRESARIAIS	323	57.1%
OUTROS	152	26.9%
ADMINISTRACAO PUBLICA	56	9.9%
ENTIDADES SEM FINS LUCRATIVOS	35	6.2%

Max length	29
Mean length	18.037
Min length	6
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_divisao
Categorical

Distinct count	60
Unique (%)	10.6%
Missing (%)	0.0%
Missing (n)	0

ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	163
COMERCIO VAREJISTA	46
COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS	40
Other values (57)	317

Toggle details

Common values
Composition

Value	Count	Frequency (%)
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	163	28.8%
COMERCIO VAREJISTA	46	8.1%
COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS	40	7.1%
EDUCACAO	33	5.8%
CONSTRUCAO DE EDIFICIOS	31	5.5%
ATIVIDADES DE ATENCAO A SAUDE HUMANA	22	3.9%
SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS	22	3.9%
COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS	21	3.7%
TRANSPORTE TERRESTRE	20	3.5%
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS	11	1.9%
Other values (50)	157	27.7%

Max length	120
Mean length	41.193
Min length	8
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_meso_regiao
Categorical

Distinct count	19
Unique (%)	3.4%
Missing (%)	12.4%
Missing (n)	70

CENTRO AMAZONENSE	138
NORTE MARANHENSE	66
CENTRO NORTE PIAUIENSE	62
Other values (15)	230
(Missing)	70

Toggle details

Common values
Composition

Value	Count	Frequency (%)
CENTRO AMAZONENSE	138	24.4%
NORTE MARANHENSE	66	11.7%
CENTRO NORTE PIAUIENSE	62	11.0%
LESTE POTIGUAR	52	9.2%
VALE DO ACRE	32	5.7%
OESTE POTIGUAR	28	4.9%
OESTE MARANHENSE	16	2.8%
SUDESTE PIAUIENSE	15	2.7%
CENTRO MARANHENSE	14	2.5%
SUDOESTE PIAUIENSE	14	2.5%
Other values (8)	59	10.4%
(Missing)	70	12.4%

Max length	22
Mean length	14.823
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_micro_regiao
Categorical

Distinct count	61
Unique (%)	10.8%
Missing (%)	12.4%
Missing (n)	70

MANAUS	126
AGLOMERACAO URBANA DE SAO LUIS	58
NATAL	48
Other values (57)	264
(Missing)	70

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MANAUS	126	22.3%
AGLOMERACAO URBANA DE SAO LUIS	58	10.2%
NATAL	48	8.5%
TERESINA	46	8.1%
RIO BRANCO	29	5.1%
MOSSORO	16	2.8%
IMPERATRIZ	12	2.1%
MEDIO MEARIM	8	1.4%
ALTO MEDIO CANINDE	8	1.4%
PICOS	7	1.2%
Other values (50)	138	24.4%
(Missing)	70	12.4%

Max length	33
Mean length	10.749
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_segmento
Categorical

Distinct count	19
Unique (%)	3.4%
Missing (%)	0.0%
Missing (n)	0

ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	163
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS	107
INDUSTRIAS DE TRANSFORMACAO	64
Other values (16)	232

Toggle details

Common values
Composition

Value	Count	Frequency (%)
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	163	28.8%
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS	107	18.9%
INDUSTRIAS DE TRANSFORMACAO	64	11.3%
CONSTRUCAO	46	8.1%
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES	42	7.4%
EDUCACAO	33	5.8%
TRANSPORTE ARMAZENAGEM E CORREIO	25	4.4%
SAUDE HUMANA E SERVICOS SOCIAIS	25	4.4%
OUTRAS ATIVIDADES DE SERVICOS	12	2.1%
ALOJAMENTO E ALIMENTACAO	11	1.9%
Other values (9)	38	6.7%

Max length	62
Mean length	39.799
Min length	8
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nu_meses_rescencia
Numeric

Distinct count	11
Unique (%)	1.9%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	24.753
Minimum	21
Maximum	49
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	21
5-th percentile	23
Q1	23
Median	23
Q3	23
95-th percentile	48
Maximum	49
Range	28
Interquartile range	0

Descriptive statistics

Standard deviation	5.923
Coef of variation	0.23929
Kurtosis	11.23
Mean	24.753
MAD	2.9508
Skewness	3.5895
Sum	14010
Variance	35.082
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[21. 22.5 23.5 24.5 25.5 26.5 27.5 47.5 48.5 49. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
23	410	72.4%
24	64	11.3%
48	29	5.1%
26	24	4.2%
22	18	3.2%
27	6	1.1%
21	5	0.9%
47	4	0.7%
25	4	0.7%
28	1	0.2%

Minimum 5 values

Value	Count	Frequency (%)
21	5	0.9%
22	18	3.2%
23	410	72.4%
24	64	11.3%
25	4	0.7%

Maximum 5 values

Value	Count	Frequency (%)
49	1	0.2%
48	29	5.1%
47	4	0.7%
28	1	0.2%
27	6	1.1%

percent_func_genero_fem
Numeric

Distinct count	535
Unique (%)	94.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	40.565
Minimum	0
Maximum	87.5
Zeros (%)	0.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	3.955
Q1	17.94
Median	42.86
Q3	61.883
95-th percentile	76.468
Maximum	87.5
Range	87.5
Interquartile range	43.943

Descriptive statistics

Standard deviation	24.417
Coef of variation	0.60193
Kurtosis	-1.2919
Mean	40.565
MAD	21.669
Skewness	-0.036441
Sum	22960
Variance	596.2
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 0. 58.07 70.125 87.5 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
50	5	0.9%
51.58	3	0.5%
72.93	3	0.5%
30.26	2	0.4%
52.01	2	0.4%
51.97	2	0.4%
3.95	2	0.4%
42.86	2	0.4%
69.14	2	0.4%
64.88	2	0.4%
Other values (525)	541	95.6%

Minimum 5 values

Value	Count	Frequency (%)
0	1	0.2%
0.5	1	0.2%
0.56	1	0.2%
0.68	2	0.4%
0.89	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
87.5	1	0.2%
87.19	1	0.2%
86.9	1	0.2%
86.26	1	0.2%
86.06	1	0.2%

percent_func_genero_masc
Numeric

Distinct count	535
Unique (%)	94.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	59.435
Minimum	12.5
Maximum	100
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	12.5
5-th percentile	23.532
Q1	38.117
Median	57.14
Q3	82.06
95-th percentile	96.045
Maximum	100
Range	87.5
Interquartile range	43.943

Descriptive statistics

Standard deviation	24.417
Coef of variation	0.41082
Kurtosis	-1.2919
Mean	59.435
MAD	21.668
Skewness	0.03644
Sum	33640
Variance	596.2
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 12.5 29.875 41.93 100. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
50	5	0.9%
48.42	3	0.5%
27.07	3	0.5%
95.65	2	0.4%
30.86	2	0.4%
35.71	2	0.4%
48.03	2	0.4%
35.11	2	0.4%
60.29	2	0.4%
41.15	2	0.4%
Other values (525)	541	95.6%

Minimum 5 values

Value	Count	Frequency (%)
12.5	1	0.2%
12.81	1	0.2%
13.1	1	0.2%
13.74	1	0.2%
13.94	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
100	1	0.2%
99.5	1	0.2%
99.44	1	0.2%
99.32	2	0.4%
99.11	1	0.2%

qt_admitidos
Numeric

Distinct count	444
Unique (%)	78.4%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	961.98
Minimum	24
Maximum	21259
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	24
5-th percentile	133.5
Q1	257.75
Median	435
Q3	904.5
95-th percentile	3936.8
Maximum	21259
Range	21235
Interquartile range	646.75

Descriptive statistics

Standard deviation	1740.2
Coef of variation	1.809
Kurtosis	42.738
Mean	961.98
MAD	873.61
Skewness	5.4655
Sum	5.4448e+05
Variance	3.0283e+06
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 24. 144.5 344.5 551.5 1153.5 2012.5 8307.5 21259. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
246	5	0.9%
419	4	0.7%
210	4	0.7%
275	4	0.7%
309	3	0.5%
311	3	0.5%
156	3	0.5%
293	3	0.5%
501	3	0.5%
270	3	0.5%
Other values (434)	531	93.8%

Minimum 5 values

Value	Count	Frequency (%)
24	1	0.2%
33	1	0.2%
53	1	0.2%
66	1	0.2%
76	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
21259	1	0.2%
11739	1	0.2%
11544	1	0.2%
11466	1	0.2%
8340	1	0.2%

qt_admitidos_12meses
Numeric

Distinct count	125
Unique (%)	22.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	37.571
Minimum	0
Maximum	1256
Zeros (%)	35.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	9
Q3	35
95-th percentile	158.75
Maximum	1256
Range	1256
Interquartile range	35

Descriptive statistics

Standard deviation	93.702
Coef of variation	2.494
Kurtosis	61.172
Mean	37.571
MAD	45.28
Skewness	6.5011
Sum	21265
Variance	8780
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0.000e+00 5.000e-01 1.850e+01 3.050e+01 7.700e+01 1.105e+02 2.390e+02 6.080e+02 1.256e+03], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	199	35.2%
10	12	2.1%
6	12	2.1%
14	11	1.9%
1	11	1.9%
16	11	1.9%
4	11	1.9%
5	10	1.8%
2	10	1.8%
7	9	1.6%
Other values (115)	270	47.7%

Minimum 5 values

Value	Count	Frequency (%)
0	199	35.2%
1	11	1.9%
2	10	1.8%
3	9	1.6%
4	11	1.9%

Maximum 5 values

Value	Count	Frequency (%)
1256	1	0.2%
642	1	0.2%
574	1	0.2%
554	2	0.4%
475	1	0.2%

qt_alteracao_socio_180d
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

qt_alteracao_socio_365d
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

qt_alteracao_socio_90d
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

qt_alteracao_socio_total
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

qt_art
Numeric

Distinct count	48
Unique (%)	8.5%
Missing (%)	53.7%
Missing (n)	304
Infinite (%)	0.0%
Infinite (n)	0

Mean	11.16
Minimum	1
Maximum	426
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	3
Q3	9
95-th percentile	43
Maximum	426
Range	425
Interquartile range	8

Descriptive statistics

Standard deviation	31.223
Coef of variation	2.7977
Kurtosis	121.19
Mean	11.16
MAD	12.57
Skewness	9.7215
Sum	2924
Variance	974.88
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	68	12.0%
2	42	7.4%
3	30	5.3%
4	18	3.2%
6	13	2.3%
5	12	2.1%
14	6	1.1%
8	6	1.1%
11	6	1.1%
10	6	1.1%
Other values (37)	55	9.7%
(Missing)	304	53.7%

Minimum 5 values

Value	Count	Frequency (%)
1	68	12.0%
2	42	7.4%
3	30	5.3%
4	18	3.2%
5	12	2.1%

Maximum 5 values

Value	Count	Frequency (%)
426	1	0.2%
126	1	0.2%
118	1	0.2%
103	1	0.2%
98	1	0.2%

qt_coligadas
Numeric

Distinct count	32
Unique (%)	5.7%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	7.1304
Minimum	1
Maximum	296
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
Median	3
Q3	7
95-th percentile	21.3
Maximum	296
Range	295
Interquartile range	5

Descriptive statistics

Standard deviation	18.999
Coef of variation	2.6644
Kurtosis	180.91
Mean	7.1304
MAD	6.6506
Skewness	12.238
Sum	2132
Variance	360.95
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	71	12.5%
2	46	8.1%
3	40	7.1%
4	32	5.7%
5	19	3.4%
6	14	2.5%
9	11	1.9%
7	10	1.8%
8	8	1.4%
10	8	1.4%
Other values (21)	40	7.1%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
1	71	12.5%
2	46	8.1%
3	40	7.1%
4	32	5.7%
5	19	3.4%

Maximum 5 values

Value	Count	Frequency (%)
296	1	0.2%
68	1	0.2%
57	1	0.2%
53	2	0.4%
48	1	0.2%

qt_coligados
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation	1

qt_coligados_agropecuaria
Numeric

Distinct count	7
Unique (%)	1.2%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.22408
Minimum	0
Maximum	9
Zeros (%)	46.8%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	1
Maximum	9
Range	9
Interquartile range	0

Descriptive statistics

Standard deviation	0.90113
Coef of variation	4.0215
Kurtosis	61.004
Mean	0.22408
MAD	0.3972
Skewness	7.0219
Sum	67
Variance	0.81204
Memory size	28.8 KiB

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	265	46.8%
1	20	3.5%
2	8	1.4%
3	3	0.5%
9	2	0.4%
4	1	0.2%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
0	265	46.8%
1	20	3.5%
2	8	1.4%
3	3	0.5%
4	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
9	2	0.4%
4	1	0.2%
3	3	0.5%
2	8	1.4%
1	20	3.5%

qt_coligados_atividade_alto
Constant

This variable is constant and should be ignored for analysis

Constant value	0.0

qt_coligados_atividade_baixo
Constant

This variable is constant and should be ignored for analysis

Constant value	0.0

qt_coligados_atividade_inativo
Constant

This variable is constant and should be ignored for analysis

Constant value	0.0

qt_coligados_atividade_medio
Constant

This variable is constant and should be ignored for analysis

Constant value	0.0

qt_coligados_atividade_mt_baixo
Constant

This variable is constant and should be ignored for analysis

Constant value	0.0

qt_coligados_ativo
Highly correlated

This variable is highly correlated with qt_coligados and should be ignored for analysis

Correlation	0.99984

qt_coligados_baixada
Boolean

Distinct count	3
Unique (%)	0.5%
Missing (%)	47.2%
Missing (n)	267

0	298
1	1
(Missing)	267

Toggle details

Value	Count	Frequency (%)
0	298	52.7%
1	1	0.2%
(Missing)	267	47.2%

qt_coligados_ccivil
Numeric

Distinct count	12
Unique (%)	2.1%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.4381
Minimum	0
Maximum	270
Zeros (%)	38.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	1
95-th percentile	3
Maximum	270
Range	270
Interquartile range	1

Descriptive statistics

Standard deviation	15.654
Coef of variation	10.885
Kurtosis	293.63
Mean	1.4381
MAD	2.257
Skewness	17.064
Sum	430
Variance	245.03
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	220	38.9%
1	48	8.5%
2	15	2.7%
3	8	1.4%
4	2	0.4%
270	1	0.2%
7	1	0.2%
8	1	0.2%
12	1	0.2%
13	1	0.2%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
0	220	38.9%
1	48	8.5%
2	15	2.7%
3	8	1.4%
4	2	0.4%

Maximum 5 values

Value	Count	Frequency (%)
270	1	0.2%
13	1	0.2%
12	1	0.2%
10	1	0.2%
8	1	0.2%

qt_coligados_centro
Numeric

Distinct count	9
Unique (%)	1.6%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.20401
Minimum	0
Maximum	13
Zeros (%)	48.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	1
Maximum	13
Range	13
Interquartile range	0

Descriptive statistics

Standard deviation	1.05
Coef of variation	5.1468
Kurtosis	89.794
Mean	0.20401
MAD	0.37118
Skewness	8.7235
Sum	61
Variance	1.1025
Memory size	28.8 KiB

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	272	48.1%
1	18	3.2%
2	4	0.7%
8	1	0.2%
3	1	0.2%
4	1	0.2%
13	1	0.2%
7	1	0.2%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
0	272	48.1%
1	18	3.2%
2	4	0.7%
3	1	0.2%
4	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
13	1	0.2%
8	1	0.2%
7	1	0.2%
4	1	0.2%
3	1	0.2%

qt_coligados_comercio
Numeric

Distinct count	15
Unique (%)	2.7%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.408
Minimum	0
Maximum	25
Zeros (%)	26.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	2
95-th percentile	6
Maximum	25
Range	25
Interquartile range	2

Descriptive statistics

Standard deviation	2.7831
Coef of variation	1.9766
Kurtosis	27.489
Mean	1.408
MAD	1.609
Skewness	4.5106
Sum	421
Variance	7.7457
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	152	26.9%
1	65	11.5%
2	28	4.9%
3	24	4.2%
4	10	1.8%
6	5	0.9%
8	4	0.7%
5	4	0.7%
14	2	0.4%
15	1	0.2%
Other values (4)	4	0.7%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
0	152	26.9%
1	65	11.5%
2	28	4.9%
3	24	4.2%
4	10	1.8%

Maximum 5 values

Value	Count	Frequency (%)
25	1	0.2%
20	1	0.2%
15	1	0.2%
14	2	0.4%
11	1	0.2%

qt_coligados_epp
Constant

This variable is constant and should be ignored for analysis

Constant value	0.0

qt_coligados_exterior
Categorical

Distinct count	4
Unique (%)	0.7%
Missing (%)	47.2%
Missing (n)	267

0	291
1	5
2	3
(Missing)	267

Toggle details

Common values
Composition

Value	Count	Frequency (%)
0	291	51.4%
1	5	0.9%
2	3	0.5%
(Missing)	267	47.2%

Max length	3
Mean length	3
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

qt_coligados_inapta
Categorical

Distinct count	4
Unique (%)	0.7%
Missing (%)	47.2%
Missing (n)	267

0	290
1	8
2	1
(Missing)	267

Toggle details

Common values
Composition

Value	Count	Frequency (%)
0	290	51.2%
1	8	1.4%
2	1	0.2%
(Missing)	267	47.2%

Max length	3
Mean length	3
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

qt_coligados_industria
Numeric

Distinct count	11
Unique (%)	1.9%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.82274
Minimum	0
Maximum	48
Zeros (%)	37.3%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	1
95-th percentile	3
Maximum	48
Range	48
Interquartile range	1

Descriptive statistics

Standard deviation	3.4367
Coef of variation	4.1771
Kurtosis	127.19
Mean	0.82274
MAD	1.1612
Skewness	10.29
Sum	246
Variance	11.811
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	211	37.3%
1	54	9.5%
2	15	2.7%
3	9	1.6%
4	3	0.5%
6	2	0.4%
21	2	0.4%
10	1	0.2%
48	1	0.2%
11	1	0.2%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
0	211	37.3%
1	54	9.5%
2	15	2.7%
3	9	1.6%
4	3	0.5%

Maximum 5 values

Value	Count	Frequency (%)
48	1	0.2%
21	2	0.4%
11	1	0.2%
10	1	0.2%
6	2	0.4%

qt_coligados_ltda
Numeric

Distinct count	6
Unique (%)	1.1%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.086957
Minimum	0
Maximum	8
Zeros (%)	50.5%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	8
Range	8
Interquartile range	0

Descriptive statistics

Standard deviation	0.61234
Coef of variation	7.0419
Kurtosis	122.72
Mean	0.086957
MAD	0.16635
Skewness	10.544
Sum	26
Variance	0.37496
Memory size	28.8 KiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	286	50.5%
1	10	1.8%
2	1	0.2%
8	1	0.2%
6	1	0.2%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
0	286	50.5%
1	10	1.8%
2	1	0.2%
6	1	0.2%
8	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
8	1	0.2%
6	1	0.2%
2	1	0.2%
1	10	1.8%
0	286	50.5%

qt_coligados_matriz
Highly correlated

This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis

Correlation	0.99904

qt_coligados_me
Constant

This variable is constant and should be ignored for analysis

Constant value	0.0

qt_coligados_mei
Boolean

Distinct count	3
Unique (%)	0.5%
Missing (%)	47.2%
Missing (n)	267

0	297
1	2
(Missing)	267

Toggle details

Value	Count	Frequency (%)
0	297	52.5%
1	2	0.4%
(Missing)	267	47.2%

qt_coligados_nordeste
Numeric

Distinct count	23
Unique (%)	4.1%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	2.8328
Minimum	0
Maximum	41
Zeros (%)	24.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	1
Q3	4
95-th percentile	13
Maximum	41
Range	41
Interquartile range	4

Descriptive statistics

Standard deviation	5.3732
Coef of variation	1.8968
Kurtosis	19.608
Mean	2.8328
MAD	3.2835
Skewness	3.8214
Sum	847
Variance	28.871
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	141	24.9%
1	39	6.9%
2	24	4.2%
4	21	3.7%
3	19	3.4%
6	10	1.8%
5	8	1.4%
9	8	1.4%
10	5	0.9%
7	3	0.5%
Other values (12)	21	3.7%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
0	141	24.9%
1	39	6.9%
2	24	4.2%
3	19	3.4%
4	21	3.7%

Maximum 5 values

Value	Count	Frequency (%)
41	2	0.4%
28	1	0.2%
25	2	0.4%
21	1	0.2%
17	2	0.4%

qt_coligados_norte
Numeric

Distinct count	20
Unique (%)	3.5%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.9398
Minimum	0
Maximum	52
Zeros (%)	28.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	2
95-th percentile	9
Maximum	52
Range	52
Interquartile range	2

Descriptive statistics

Standard deviation	4.657
Coef of variation	2.4008
Kurtosis	51.956
Mean	1.9398
MAD	2.4025
Skewness	6.0715
Sum	580
Variance	21.688
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	159	28.1%
1	54	9.5%
2	22	3.9%
3	18	3.2%
4	11	1.9%
5	8	1.4%
6	4	0.7%
7	4	0.7%
9	4	0.7%
14	3	0.5%
Other values (9)	12	2.1%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
0	159	28.1%
1	54	9.5%
2	22	3.9%
3	18	3.2%
4	11	1.9%

Maximum 5 values

Value	Count	Frequency (%)
52	1	0.2%
32	1	0.2%
23	1	0.2%
19	1	0.2%
17	1	0.2%

qt_coligados_nula
Constant

This variable is constant and should be ignored for analysis

Constant value	0.0

qt_coligados_sa
Highly correlated

This variable is highly correlated with qt_coligados_industria and should be ignored for analysis

Correlation	0.92957

qt_coligados_serviço
Numeric

Distinct count	26
Unique (%)	4.6%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.2441
Minimum	0
Maximum	51
Zeros (%)	10.8%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
Median	1
Q3	3
95-th percentile	12
Maximum	51
Range	51
Interquartile range	2

Descriptive statistics

Standard deviation	5.6245
Coef of variation	1.7337
Kurtosis	25.503
Mean	3.2441
MAD	3.16
Skewness	4.371
Sum	970
Variance	31.635
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	93	16.4%
0	61	10.8%
2	48	8.5%
3	25	4.4%
4	19	3.4%
7	14	2.5%
12	6	1.1%
6	6	1.1%
5	6	1.1%
8	4	0.7%
Other values (15)	17	3.0%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
0	61	10.8%
1	93	16.4%
2	48	8.5%
3	25	4.4%
4	19	3.4%

Maximum 5 values

Value	Count	Frequency (%)
51	1	0.2%
37	1	0.2%
31	1	0.2%
30	1	0.2%
25	1	0.2%

qt_coligados_sudeste
Highly correlated

This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis

Correlation	0.92867

qt_coligados_sul
Numeric

Distinct count	6
Unique (%)	1.1%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.11037
Minimum	0
Maximum	16
Zeros (%)	50.7%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	16
Range	16
Interquartile range	0

Descriptive statistics

Standard deviation	1.0056
Coef of variation	9.1115
Kurtosis	214.49
Mean	0.11037
MAD	0.21188
Skewness	14.048
Sum	33
Variance	1.0113
Memory size	28.8 KiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	287	50.7%
1	9	1.6%
2	1	0.2%
6	1	0.2%
16	1	0.2%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
0	287	50.7%
1	9	1.6%
2	1	0.2%
6	1	0.2%
16	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
16	1	0.2%
6	1	0.2%
2	1	0.2%
1	9	1.6%
0	287	50.7%

qt_coligados_suspensa
Constant

This variable is constant and should be ignored for analysis

Constant value	0.0

qt_desligados
Numeric

Distinct count	414
Unique (%)	73.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	591.69
Minimum	7
Maximum	11079
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	7
5-th percentile	28.5
Q1	120
Median	238
Q3	544.25
95-th percentile	2180
Maximum	11079
Range	11072
Interquartile range	424.25

Descriptive statistics

Standard deviation	1141.4
Coef of variation	1.9291
Kurtosis	30.347
Mean	591.69
MAD	585.06
Skewness	4.9176
Sum	3.349e+05
Variance	1.3028e+06
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[7.0000e+00 2.6900e+02 5.4350e+02 9.1750e+02 1.8270e+03 4.3580e+03 1.1079e+04], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
199	5	0.9%
124	5	0.9%
214	4	0.7%
378	4	0.7%
221	4	0.7%
153	4	0.7%
9	3	0.5%
89	3	0.5%
52	3	0.5%
106	3	0.5%
Other values (404)	528	93.3%

Minimum 5 values

Value	Count	Frequency (%)
7	1	0.2%
8	3	0.5%
9	3	0.5%
10	1	0.2%
11	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
11079	1	0.2%
9979	1	0.2%
7843	1	0.2%
7233	1	0.2%
6802	1	0.2%

qt_desligados_12meses
Numeric

Distinct count	111
Unique (%)	19.6%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	31.654
Minimum	0
Maximum	1041
Zeros (%)	33.0%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	9
Q3	29
95-th percentile	119.5
Maximum	1041
Range	1041
Interquartile range	29

Descriptive statistics

Standard deviation	78.75
Coef of variation	2.4879
Kurtosis	58.536
Mean	31.654
MAD	37.434
Skewness	6.3919
Sum	17916
Variance	6201.6
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0.000e+00 5.000e-01 2.250e+01 5.450e+01 9.400e+01 1.565e+02 5.185e+02 1.041e+03], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	187	33.0%
10	16	2.8%
7	15	2.7%
1	13	2.3%
4	11	1.9%
5	11	1.9%
6	11	1.9%
15	11	1.9%
12	11	1.9%
18	11	1.9%
Other values (101)	269	47.5%

Minimum 5 values

Value	Count	Frequency (%)
0	187	33.0%
1	13	2.3%
2	10	1.8%
3	9	1.6%
4	11	1.9%

Maximum 5 values

Value	Count	Frequency (%)
1041	1	0.2%
557	1	0.2%
480	1	0.2%
460	1	0.2%
443	1	0.2%

qt_ex_funcionarios
Highly correlated

This variable is highly correlated with qt_desligados and should be ignored for analysis

Correlation	1

qt_filiais
Numeric

Distinct count	35
Unique (%)	6.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.4346
Minimum	0
Maximum	172
Zeros (%)	47.7%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	1
Q3	2
95-th percentile	13
Maximum	172
Range	172
Interquartile range	2

Descriptive statistics

Standard deviation	11.804
Coef of variation	3.4367
Kurtosis	106.49
Mean	3.4346
MAD	4.4989
Skewness	9.2098
Sum	1944
Variance	139.33
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 3.5 6.5 10.5 16.5 56. 172. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	270	47.7%
1	108	19.1%
2	49	8.7%
3	29	5.1%
4	18	3.2%
6	18	3.2%
5	10	1.8%
7	9	1.6%
10	8	1.4%
8	6	1.1%
Other values (25)	41	7.2%

Minimum 5 values

Value	Count	Frequency (%)
0	270	47.7%
1	108	19.1%
2	49	8.7%
3	29	5.1%
4	18	3.2%

Maximum 5 values

Value	Count	Frequency (%)
172	1	0.2%
121	1	0.2%
116	1	0.2%
61	1	0.2%
51	1	0.2%

qt_funcionarios
Highly correlated

This variable is highly correlated with idade_de_54_a_58 and should be ignored for analysis

Correlation	0.94732

qt_funcionarios_12meses
Highly correlated

This variable is highly correlated with qt_funcionarios and should be ignored for analysis

Correlation	0.99761

qt_funcionarios_24meses
Highly correlated

This variable is highly correlated with qt_funcionarios_12meses and should be ignored for analysis

Correlation	0.98334

qt_funcionarios_coligados
Numeric

Distinct count	163
Unique (%)	28.8%
Missing (%)	55.5%
Missing (n)	314
Infinite (%)	0.0%
Infinite (n)	0

Mean	359.66
Minimum	0
Maximum	7222
Zeros (%)	3.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	10.75
Median	80.5
Q3	229.25
95-th percentile	1727.7
Maximum	7222
Range	7222
Interquartile range	218.5

Descriptive statistics

Standard deviation	897.39
Coef of variation	2.4951
Kurtosis	21.645
Mean	359.66
MAD	460.51
Skewness	4.3418
Sum	90635
Variance	8.053e+05
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	18	3.2%
1	9	1.6%
3	7	1.2%
2	5	0.9%
4	4	0.7%
9	4	0.7%
7	4	0.7%
6	4	0.7%
12	3	0.5%
20	3	0.5%
Other values (152)	191	33.7%
(Missing)	314	55.5%

Minimum 5 values

Value	Count	Frequency (%)
0	18	3.2%
1	9	1.6%
2	5	0.9%
3	7	1.2%
4	4	0.7%

Maximum 5 values

Value	Count	Frequency (%)
7222	1	0.2%
4770	1	0.2%
4487	1	0.2%
4311	1	0.2%
4124	1	0.2%

qt_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with media_filiais_coligados and should be ignored for analysis

Correlation	0.90605

qt_funcionarios_grupo
Numeric

Distinct count	351
Unique (%)	62.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	580.98
Minimum	17
Maximum	95202
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	17
5-th percentile	60.25
Q1	99
Median	178
Q3	375.25
95-th percentile	1285.2
Maximum	95202
Range	95185
Interquartile range	276.25

Descriptive statistics

Standard deviation	4111.2
Coef of variation	7.0762
Kurtosis	499.53
Mean	580.98
MAD	662.11
Skewness	21.811
Sum	3.2884e+05
Variance	1.6902e+07
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[1.7000e+01 4.9500e+01 1.2750e+02 2.1350e+02 4.1450e+02 7.8950e+02 1.6140e+03 6.3160e+03 9.5202e+04], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
96	7	1.2%
98	7	1.2%
71	7	1.2%
94	6	1.1%
123	6	1.1%
142	6	1.1%
110	5	0.9%
77	5	0.9%
73	5	0.9%
79	4	0.7%
Other values (341)	508	89.8%

Minimum 5 values

Value	Count	Frequency (%)
17	1	0.2%
21	1	0.2%
38	1	0.2%
40	1	0.2%
42	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
95202	1	0.2%
17969	1	0.2%
6622	1	0.2%
6010	1	0.2%
5759	1	0.2%

qt_ramos_coligados
Numeric

Distinct count	22
Unique (%)	3.9%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	4.1304
Minimum	1
Maximum	30
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	3
Q3	5
95-th percentile	12.1
Maximum	30
Range	29
Interquartile range	4

Descriptive statistics

Standard deviation	4.1893
Coef of variation	1.0142
Kurtosis	11.049
Mean	4.1304
MAD	2.7887
Skewness	2.8221
Sum	1235
Variance	17.55
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	76	13.4%
2	54	9.5%
3	53	9.4%
4	31	5.5%
5	20	3.5%
7	14	2.5%
8	11	1.9%
6	10	1.8%
10	9	1.6%
15	3	0.5%
Other values (11)	18	3.2%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
1	76	13.4%
2	54	9.5%
3	53	9.4%
4	31	5.5%
5	20	3.5%

Maximum 5 values

Value	Count	Frequency (%)
30	2	0.4%
21	1	0.2%
19	1	0.2%
18	2	0.4%
17	1	0.2%

qt_regioes_coligados
Numeric

Distinct count	6
Unique (%)	1.1%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.3445
Minimum	1
Maximum	5
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	1
Q3	1.5
95-th percentile	3
Maximum	5
Range	4
Interquartile range	0.5

Descriptive statistics

Standard deviation	0.69398
Coef of variation	0.51617
Kurtosis	6.1631
Mean	1.3445
MAD	0.51615
Skewness	2.3901
Sum	402
Variance	0.48161
Memory size	28.8 KiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	224	39.6%
2	56	9.9%
3	11	1.9%
4	7	1.2%
5	1	0.2%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
1	224	39.6%
2	56	9.9%
3	11	1.9%
4	7	1.2%
5	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
5	1	0.2%
4	7	1.2%
3	11	1.9%
2	56	9.9%
1	224	39.6%

qt_socios
Numeric

Distinct count	15
Unique (%)	2.7%
Missing (%)	32.5%
Missing (n)	184
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.0995
Minimum	1
Maximum	139
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
Median	2
Q3	3
95-th percentile	6
Maximum	139
Range	138
Interquartile range	1

Descriptive statistics

Standard deviation	7.2366
Coef of variation	2.3348
Kurtosis	328.78
Mean	3.0995
MAD	1.6803
Skewness	17.547
Sum	1184
Variance	52.368
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	181	32.0%
3	65	11.5%
1	55	9.7%
4	42	7.4%
5	14	2.5%
6	13	2.3%
7	3	0.5%
9	3	0.5%
139	1	0.2%
13	1	0.2%
Other values (4)	4	0.7%
(Missing)	184	32.5%

Minimum 5 values

Value	Count	Frequency (%)
1	55	9.7%
2	181	32.0%
3	65	11.5%
4	42	7.4%
5	14	2.5%

Maximum 5 values

Value	Count	Frequency (%)
139	1	0.2%
22	1	0.2%
14	1	0.2%
13	1	0.2%
12	1	0.2%

qt_socios_coligados
Highly correlated

This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis

Correlation	0.96791

qt_socios_feminino
Highly correlated

This variable is highly correlated with qt_socios and should be ignored for analysis

Correlation	0.98778

qt_socios_masculino
Highly correlated

This variable is highly correlated with qt_socios_feminino and should be ignored for analysis

Correlation	0.96613

qt_socios_pep
Highly correlated

This variable is highly correlated with qt_socios_masculino and should be ignored for analysis

Correlation	0.97676

qt_socios_pf
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation	0.9745

qt_socios_pj
Categorical

Distinct count	5
Unique (%)	0.9%
Missing (%)	32.5%
Missing (n)	184

0	331
1	35
2	15
(Missing)	184

Toggle details

Common values
Composition

Value	Count	Frequency (%)
0	331	58.5%
1	35	6.2%
2	15	2.7%
3	1	0.2%
(Missing)	184	32.5%

Max length	3
Mean length	3
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

qt_socios_pj_ativos
Highly correlated

This variable is highly correlated with qt_socios_pj and should be ignored for analysis

Correlation	0.96283

qt_socios_pj_baixados
Boolean

Distinct count	3
Unique (%)	0.5%
Missing (%)	91.0%
Missing (n)	515

0	50
1	1
(Missing)	515

Toggle details

Value	Count	Frequency (%)
0	50	8.8%
1	1	0.2%
(Missing)	515	91.0%

qt_socios_pj_inaptos
Constant

This variable is constant and should be ignored for analysis

Constant value	0.0

qt_socios_pj_nulos
Constant

This variable is constant and should be ignored for analysis

Constant value	0.0

qt_socios_pj_suspensos
Constant

This variable is constant and should be ignored for analysis

Constant value	0.0

qt_socios_st_regular
Highly correlated

This variable is highly correlated with qt_socios_pf and should be ignored for analysis

Correlation	0.99433

qt_socios_st_suspensa
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

qt_ufs_coligados
Numeric

Distinct count	12
Unique (%)	2.1%
Missing (%)	47.2%
Missing (n)	267
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.7458
Minimum	1
Maximum	11
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	1
Q3	2
95-th percentile	5
Maximum	11
Range	10
Interquartile range	1

Descriptive statistics

Standard deviation	1.5573
Coef of variation	0.892
Kurtosis	14.305
Mean	1.7458
MAD	0.95784
Skewness	3.4833
Sum	522
Variance	2.4251
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	192	33.9%
2	64	11.3%
3	22	3.9%
5	6	1.1%
4	4	0.7%
6	3	0.5%
7	2	0.4%
11	2	0.4%
9	2	0.4%
10	1	0.2%
(Missing)	267	47.2%

Minimum 5 values

Value	Count	Frequency (%)
1	192	33.9%
2	64	11.3%
3	22	3.9%
4	4	0.7%
5	6	1.1%

Maximum 5 values

Value	Count	Frequency (%)
11	2	0.4%
10	1	0.2%
9	2	0.4%
8	1	0.2%
7	2	0.4%

setor
Categorical

Distinct count	5
Unique (%)	0.9%
Missing (%)	0.0%
Missing (n)	0

SERVIÇO	336
COMERCIO	107
INDUSTRIA	69
Other values (2)	54

Toggle details

Common values
Composition

Value	Count	Frequency (%)
SERVIÇO	336	59.4%
COMERCIO	107	18.9%
INDUSTRIA	69	12.2%
CONSTRUÇÃO CIVIL	46	8.1%
AGROPECUARIA	8	1.4%

Max length	16
Mean length	8.235
Min length	7
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

sg_uf
Categorical

Distinct count	6
Unique (%)	1.1%
Missing (%)	0.0%
Missing (n)	0

AM	142
MA	118
PI	101
Other values (3)	205

Toggle details

Common values
Composition

Value	Count	Frequency (%)
AM	142	25.1%
MA	118	20.8%
PI	101	17.8%
RN	100	17.7%
RO	70	12.4%
AC	35	6.2%

Max length	2
Mean length	2
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

sg_uf_matriz
Categorical

Distinct count	6
Unique (%)	1.1%
Missing (%)	0.0%
Missing (n)	0

AM	142
MA	118
PI	101
Other values (3)	205

Toggle details

Common values
Composition

Value	Count	Frequency (%)
AM	142	25.1%
MA	118	20.8%
PI	101	17.8%
RN	100	17.7%
RO	70	12.4%
AC	35	6.2%

Max length	2
Mean length	2
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

sum_faturamento_estimado_coligadas
Highly correlated

This variable is highly correlated with faturamento_est_coligados_gp and should be ignored for analysis

Correlation	0.96717

total
Highly correlated

This variable is highly correlated with qt_funcionarios_24meses and should be ignored for analysis

Correlation	0.97843

total_filiais_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados_gp and should be ignored for analysis

Correlation	0.92158

tx_crescimento_12meses
Numeric

Distinct count	355
Unique (%)	62.7%
Missing (%)	0.2%
Missing (n)	1
Infinite (%)	0.0%
Infinite (n)	0

Mean	4.7448
Minimum	-79.462
Maximum	376.32
Zeros (%)	34.5%

Toggle details

Quantile statistics

Minimum	-79.462
5-th percentile	-18.051
Q1	-0.98039
Median	0
Q3	5
95-th percentile	35.846
Maximum	376.32
Range	455.78
Interquartile range	5.9804

Descriptive statistics

Standard deviation	28.294
Coef of variation	5.9632
Kurtosis	74.962
Mean	4.7448
MAD	12.075
Skewness	6.9998
Sum	2680.8
Variance	800.55
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	195	34.5%
1.0638	3	0.5%
2.5641	3	0.5%
11.321	2	0.4%
-6.8966	2	0.4%
21.905	2	0.4%
-1.3514	2	0.4%
2.7027	2	0.4%
10.169	2	0.4%
-2.0202	2	0.4%
Other values (344)	350	61.8%

Minimum 5 values

Value	Count	Frequency (%)
-79.462	1	0.2%
-65.948	1	0.2%
-44.304	1	0.2%
-41.27	1	0.2%
-40.854	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
376.32	1	0.2%
290.48	1	0.2%
181.55	1	0.2%
133.33	1	0.2%
126.67	1	0.2%

tx_crescimento_24meses
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation	0.96385

tx_rotatividade
Numeric

Distinct count	362
Unique (%)	64.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	13.801
Minimum	0
Maximum	133.88
Zeros (%)	33.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	8.4636
Q3	19.84
95-th percentile	46.42
Maximum	133.88
Range	133.88
Interquartile range	19.84

Descriptive statistics

Standard deviation	18.288
Coef of variation	1.3251
Kurtosis	8.8707
Mean	13.801
MAD	12.95
Skewness	2.4553
Sum	7811.1
Variance	334.44
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0.00000000e+00 1.39295166e-02 2.26734117e+01 4.26816479e+01 5.92415730e+01 1.33877551e+02], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	188	33.2%
38.462	3	0.5%
22.642	2	0.4%
5.2288	2	0.4%
19.512	2	0.4%
27.586	2	0.4%
19.355	2	0.4%
10.909	2	0.4%
8.2759	2	0.4%
10.811	2	0.4%
Other values (352)	359	63.4%

Minimum 5 values

Value	Count	Frequency (%)
0	188	33.2%
0.027859	1	0.2%
0.13387	1	0.2%
0.14316	1	0.2%
0.28902	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
133.88	1	0.2%
114.43	1	0.2%
113.96	1	0.2%
106.67	1	0.2%
95.904	1	0.2%

vl_faturamento_estimado_aux
Numeric

Distinct count	480
Unique (%)	84.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	8.1049e+07
Minimum	1.0015e+07
Maximum	3.4909e+09
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1.0015e+07
5-th percentile	1.1024e+07
Q1	1.8507e+07
Median	3.0406e+07
Q3	6.3313e+07
95-th percentile	2.9249e+08
Maximum	3.4909e+09
Range	3.4809e+09
Interquartile range	4.4806e+07

Descriptive statistics

Standard deviation	2.2205e+08
Coef of variation	2.7398
Kurtosis	119.27
Mean	8.1049e+07
MAD	8.2627e+07
Skewness	9.5819
Sum	4.5874e+10
Variance	4.9308e+16
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[1.00147100e+07 1.25183880e+07 3.11414220e+07 4.10840100e+07 7.22769500e+07 1.53105555e+08 5.26290040e+08 3.49093020e+09], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1.1024e+07	5	0.9%
1.9267e+07	5	0.9%
2.7355e+07	3	0.5%
1.1591e+07	3	0.5%
1.7515e+07	3	0.5%
1.2467e+07	3	0.5%
2.1328e+07	3	0.5%
1.0046e+07	3	0.5%
1.5764e+07	3	0.5%
1.1746e+07	3	0.5%
Other values (470)	532	94.0%

Minimum 5 values

Value	Count	Frequency (%)
1.0015e+07	1	0.2%
1.0046e+07	3	0.5%
1.0097e+07	2	0.4%
1.0138e+07	1	0.2%
1.0149e+07	2	0.4%

Maximum 5 values

Value	Count	Frequency (%)
3.4909e+09	1	0.2%
2.0688e+09	1	0.2%
1.7005e+09	1	0.2%
1.5354e+09	1	0.2%
1.3759e+09	1	0.2%

vl_faturamento_estimado_grupo_aux
Numeric

Distinct count	528
Unique (%)	93.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.99e+07
Minimum	1.0015e+07
Maximum	4.6638e+09
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1.0015e+07
5-th percentile	1.1552e+07
Q1	2.0204e+07
Median	3.493e+07
Q3	7.5112e+07
95-th percentile	3.2661e+08
Maximum	4.6638e+09
Range	4.6538e+09
Interquartile range	5.4908e+07

Descriptive statistics

Standard deviation	3.0304e+08
Coef of variation	3.0334
Kurtosis	125.51
Mean	9.99e+07
MAD	1.0515e+08
Skewness	10.055
Sum	5.6543e+10
Variance	9.1831e+16
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[1.00147100e+07 3.09921700e+07 6.07708500e+07 9.03075470e+07 1.53592375e+08 2.69689685e+08 6.77425150e+08 4.66380100e+09], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1.1024e+07	5	0.9%
1.1746e+07	3	0.5%
2.7355e+07	3	0.5%
4.0955e+07	3	0.5%
1.0921e+07	3	0.5%
3.0497e+07	3	0.5%
1.2312e+07	2	0.4%
2.1328e+07	2	0.4%
4.0131e+07	2	0.4%
1.0097e+07	2	0.4%
Other values (518)	538	95.1%

Minimum 5 values

Value	Count	Frequency (%)
1.0015e+07	1	0.2%
1.0046e+07	2	0.4%
1.0097e+07	2	0.4%
1.0138e+07	1	0.2%
1.0406e+07	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
4.6638e+09	1	0.2%
3.52e+09	1	0.2%
2.0777e+09	1	0.2%
1.7005e+09	1	0.2%
1.5545e+09	1	0.2%

vl_folha_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados and should be ignored for analysis

Correlation	0.92165

vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with max_vl_folha_coligados_gp and should be ignored for analysis

Correlation	0.90572

vl_frota
Numeric

Distinct count	467
Unique (%)	82.5%
Missing (%)	17.3%
Missing (n)	98
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.6479e+05
Minimum	3435
Maximum	3.832e+07
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	3435
5-th percentile	25751
Q1	1.0064e+05
Median	2.9737e+05
Q3	6.3126e+05
95-th percentile	3.7128e+06
Maximum	3.832e+07
Range	3.8317e+07
Interquartile range	5.3062e+05

Descriptive statistics

Standard deviation	2.7903e+06
Coef of variation	2.8922
Kurtosis	78.569
Mean	9.6479e+05
MAD	1.1407e+06
Skewness	7.5687
Sum	4.5152e+08
Variance	7.7859e+12
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1.739e+05	2	0.4%
64657	2	0.4%
2.7255e+05	1	0.2%
40655	1	0.2%
59795	1	0.2%
5.8706e+05	1	0.2%
3.0684e+05	1	0.2%
2.5454e+05	1	0.2%
6.7206e+05	1	0.2%
34236	1	0.2%
Other values (456)	456	80.6%
(Missing)	98	17.3%

Minimum 5 values

Value	Count	Frequency (%)
3435	1	0.2%
3611	1	0.2%
3705	1	0.2%
4361	1	0.2%
4610	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
3.832e+07	1	0.2%
1.866e+07	1	0.2%
1.6423e+07	1	0.2%
1.5787e+07	1	0.2%
1.5604e+07	1	0.2%

vl_idade_maxima_socios_pj
Numeric

Distinct count	51
Unique (%)	9.0%
Missing (%)	91.0%
Missing (n)	515
Infinite (%)	0.0%
Infinite (n)	0

Mean	13.374
Minimum	0.76112
Maximum	52.282
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	0.76112
5-th percentile	1.6605
Q1	4.1821
Median	7.102
Q3	18.658
95-th percentile	39.648
Maximum	52.282
Range	51.521
Interquartile range	14.476

Descriptive statistics

Standard deviation	12.985
Coef of variation	0.9709
Kurtosis	1.3448
Mean	13.374
MAD	10.24
Skewness	1.4101
Sum	682.1
Variance	168.62
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
15.343	2	0.4%
17.298	1	0.2%
4.0794	1	0.2%
3.5565	1	0.2%
12.159	1	0.2%
34.242	1	0.2%
19.121	1	0.2%
2.0616	1	0.2%
0.8679	1	0.2%
15.439	1	0.2%
Other values (40)	40	7.1%
(Missing)	515	91.0%

Minimum 5 values

Value	Count	Frequency (%)
0.76112	1	0.2%
0.8679	1	0.2%
1.3388	1	0.2%
1.9822	1	0.2%
2.0616	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
52.282	1	0.2%
49.374	1	0.2%
41.402	1	0.2%
37.895	1	0.2%
34.242	1	0.2%

vl_idade_media_socios_pj
Highly correlated

This variable is highly correlated with vl_idade_maxima_socios_pj and should be ignored for analysis

Correlation	0.93323

vl_idade_minima_socios_pj
Highly correlated

This variable is highly correlated with vl_idade_media_socios_pj and should be ignored for analysis

Correlation	0.92519

vl_potenc_cons_oleo_gas
Numeric

Distinct count	62
Unique (%)	11.0%
Missing (%)	83.4%
Missing (n)	472
Infinite (%)	0.0%
Infinite (n)	0

Mean	78.468
Minimum	1
Maximum	1080
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	3
Q1	14.25
Median	44.5
Q3	81.5
95-th percentile	308.45
Maximum	1080
Range	1079
Interquartile range	67.25

Descriptive statistics

Standard deviation	136.42
Coef of variation	1.7385
Kurtosis	31.586
Mean	78.468
MAD	73.751
Skewness	4.8865
Sum	7376
Variance	18610
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
45	8	1.4%
6	5	0.9%
4	5	0.9%
18	4	0.7%
20	3	0.5%
3	3	0.5%
7	3	0.5%
60	3	0.5%
30	2	0.4%
2	2	0.4%
Other values (51)	56	9.9%
(Missing)	472	83.4%

Minimum 5 values

Value	Count	Frequency (%)
1	1	0.2%
2	2	0.4%
3	3	0.5%
4	5	0.9%
5	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
1080	1	0.2%
430	1	0.2%
380	1	0.2%
374	1	0.2%
352	1	0.2%

vl_total_tancagem
Highly correlated

This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis

Correlation	0.94313

vl_total_tancagem_grupo
Numeric

Distinct count	11
Unique (%)	1.9%
Missing (%)	94.7%
Missing (n)	536
Infinite (%)	0.0%
Infinite (n)	0

Mean	45.867
Minimum	10
Maximum	385
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	10
5-th percentile	15
Q1	15
Median	17.5
Q3	30
95-th percentile	177.5
Maximum	385
Range	375
Interquartile range	15

Descriptive statistics

Standard deviation	78.134
Coef of variation	1.7035
Kurtosis	13.537
Mean	45.867
MAD	42.169
Skewness	3.6079
Sum	1376
Variance	6104.9
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
15	14	2.5%
30	5	0.9%
20	3	0.5%
45	2	0.4%
245	1	0.2%
385	1	0.2%
10	1	0.2%
91	1	0.2%
95	1	0.2%
40	1	0.2%
(Missing)	536	94.7%

Minimum 5 values

Value	Count	Frequency (%)
10	1	0.2%
15	14	2.5%
20	3	0.5%
30	5	0.9%
40	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
385	1	0.2%
245	1	0.2%
95	1	0.2%
91	1	0.2%
45	2	0.4%

vl_total_veiculos_antt
Highly correlated

This variable is highly correlated with vl_total_tancagem_grupo and should be ignored for analysis

Correlation	0.9644

vl_total_veiculos_antt_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_antt and should be ignored for analysis

Correlation	1

vl_total_veiculos_leves
Numeric

Distinct count	59
Unique (%)	10.4%
Missing (%)	13.4%
Missing (n)	76
Infinite (%)	0.0%
Infinite (n)	0

Mean	11.645
Minimum	0
Maximum	359
Zeros (%)	8.3%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
Median	5
Q3	10
95-th percentile	41.55
Maximum	359
Range	359
Interquartile range	8

Descriptive statistics

Standard deviation	27.507
Coef of variation	2.3621
Kurtosis	64.13
Mean	11.645
MAD	12.088
Skewness	6.8574
Sum	5706
Variance	756.62
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	61	10.8%
2	51	9.0%
0	47	8.3%
3	46	8.1%
5	38	6.7%
4	33	5.8%
6	23	4.1%
7	23	4.1%
10	19	3.4%
9	17	3.0%
Other values (48)	132	23.3%
(Missing)	76	13.4%

Minimum 5 values

Value	Count	Frequency (%)
0	47	8.3%
1	61	10.8%
2	51	9.0%
3	46	8.1%
4	33	5.8%

Maximum 5 values

Value	Count	Frequency (%)
359	1	0.2%
194	1	0.2%
170	1	0.2%
167	1	0.2%
164	1	0.2%

vl_total_veiculos_leves_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_leves and should be ignored for analysis

Correlation	0.95902

vl_total_veiculos_pesados
Numeric

Distinct count	59
Unique (%)	10.4%
Missing (%)	13.4%
Missing (n)	76
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.849
Minimum	0
Maximum	215
Zeros (%)	29.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	2
Q3	8
95-th percentile	46
Maximum	215
Range	215
Interquartile range	8

Descriptive statistics

Standard deviation	24.115
Coef of variation	2.4485
Kurtosis	30.729
Mean	9.849
MAD	12.202
Skewness	5.0185
Sum	4826
Variance	581.52
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	165	29.2%
1	55	9.7%
2	42	7.4%
3	29	5.1%
4	24	4.2%
7	19	3.4%
5	15	2.7%
9	14	2.5%
6	13	2.3%
8	11	1.9%
Other values (48)	103	18.2%
(Missing)	76	13.4%

Minimum 5 values

Value	Count	Frequency (%)
0	165	29.2%
1	55	9.7%
2	42	7.4%
3	29	5.1%
4	24	4.2%

Maximum 5 values

Value	Count	Frequency (%)
215	1	0.2%
190	1	0.2%
187	1	0.2%
176	1	0.2%
142	1	0.2%

vl_total_veiculos_pesados_grupo
Numeric

Distinct count	65
Unique (%)	11.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	10.408
Minimum	0
Maximum	663
Zeros (%)	41.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	1
Q3	7
95-th percentile	46
Maximum	663
Range	663
Interquartile range	7

Descriptive statistics

Standard deviation	36.866
Coef of variation	3.542
Kurtosis	179.17
Mean	10.408
MAD	13.944
Skewness	11.328
Sum	5891
Variance	1359.1
Memory size	28.8 KiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0.000e+00 5.000e-01 2.500e+00 4.500e+00 1.050e+01 2.050e+01 4.950e+01 2.025e+02 6.630e+02], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	237	41.9%
1	54	9.5%
2	41	7.2%
3	28	4.9%
4	25	4.4%
5	17	3.0%
7	16	2.8%
6	15	2.7%
9	13	2.3%
10	10	1.8%
Other values (55)	110	19.4%

Minimum 5 values

Value	Count	Frequency (%)
0	237	41.9%
1	54	9.5%
2	41	7.2%
3	28	4.9%
4	25	4.4%

Maximum 5 values

Value	Count	Frequency (%)
663	1	0.2%
215	1	0.2%
190	1	0.2%
187	1	0.2%
179	1	0.2%

First rows

	coligada_mais_antiga_ativa	coligada_mais_antiga_baixada	coligada_mais_nova_ativa	coligada_mais_nova_baixada	de_faixa_faturamento_estimado	de_faixa_faturamento_estimado_grupo	de_indicador_telefone	de_natureza_juridica	de_nivel_atividade	de_ramo	de_saude_rescencia	de_saude_tributaria	dt_situacao	empsetorcensitariofaixarendapopulacao	faturamento_est_coligados	faturamento_est_coligados_gp	fl_antt	fl_email	fl_epp	fl_ltda	fl_matriz	fl_me	fl_mei	fl_optante_simei	fl_optante_simples	fl_passivel_iss	fl_rm	fl_sa	fl_simples_irregular	fl_spa	fl_st_especial	fl_telefone	fl_veiculo	grau_instrucao_macro_analfabeto	grau_instrucao_macro_desconhecido	grau_instrucao_macro_escolaridade_fundamental	grau_instrucao_macro_escolaridade_media	grau_instrucao_macro_escolaridade_superior	id	idade_acima_de_58	idade_ate_18	idade_de_19_a_23	idade_de_24_a_28	idade_de_29_a_33	idade_de_34_a_38	idade_de_39_a_43	idade_de_44_a_48	idade_de_49_a_53	idade_de_54_a_58	idade_emp_cat	idade_empresa_anos	idade_maxima_coligadas	idade_maxima_socios	idade_media_coligadas	idade_media_coligadas_ativas	idade_media_coligadas_baixadas	idade_media_socios	idade_minima_coligadas	idade_minima_socios	max_faturamento_est_coligados	max_faturamento_est_coligados_gp	max_filiais_coligados	max_funcionarios_coligados_gp	max_meses_servicos	max_meses_servicos_all	max_vl_folha_coligados	max_vl_folha_coligados_gp	media_faturamento_est_coligados	media_faturamento_est_coligados_gp	media_filiais_coligados	media_funcionarios_coligados_gp	media_meses_servicos	media_meses_servicos_all	media_vl_folha_coligados	media_vl_folha_coligados_gp	meses_ultima_contratacaco	min_faturamento_est_coligados	min_faturamento_est_coligados_gp	min_filiais_coligados	min_funcionarios_coligados_gp	min_meses_servicos	min_meses_servicos_all	min_vl_folha_coligados	min_vl_folha_coligados_gp	natureza_juridica_macro	nm_divisao	nm_meso_regiao	nm_micro_regiao	nm_segmento	nu_meses_rescencia	percent_func_genero_fem	percent_func_genero_masc	qt_admitidos	qt_admitidos_12meses	qt_alteracao_socio_180d	qt_alteracao_socio_365d	qt_alteracao_socio_90d	qt_alteracao_socio_total	qt_art	qt_coligadas	qt_coligados	qt_coligados_agropecuaria	qt_coligados_atividade_alto	qt_coligados_atividade_baixo	qt_coligados_atividade_inativo	qt_coligados_atividade_medio	qt_coligados_atividade_mt_baixo	qt_coligados_ativo	qt_coligados_baixada	qt_coligados_ccivil	qt_coligados_centro	qt_coligados_comercio	qt_coligados_epp	qt_coligados_exterior	qt_coligados_inapta	qt_coligados_industria	qt_coligados_ltda	qt_coligados_matriz	qt_coligados_me	qt_coligados_mei	qt_coligados_nordeste	qt_coligados_norte	qt_coligados_nula	qt_coligados_sa	qt_coligados_serviço	qt_coligados_sudeste	qt_coligados_sul	qt_coligados_suspensa	qt_desligados	qt_desligados_12meses	qt_ex_funcionarios	qt_filiais	qt_funcionarios	qt_funcionarios_12meses	qt_funcionarios_24meses	qt_funcionarios_coligados	qt_funcionarios_coligados_gp	qt_funcionarios_grupo	qt_ramos_coligados	qt_regioes_coligados	qt_socios	qt_socios_coligados	qt_socios_feminino	qt_socios_masculino	qt_socios_pep	qt_socios_pf	qt_socios_pj	qt_socios_pj_ativos	qt_socios_pj_baixados	qt_socios_pj_inaptos	qt_socios_pj_nulos	qt_socios_pj_suspensos	qt_socios_st_regular	qt_socios_st_suspensa	qt_ufs_coligados	setor	sg_uf	sg_uf_matriz	sum_faturamento_estimado_coligadas	total	total_filiais_coligados	tx_crescimento_12meses	tx_crescimento_24meses	tx_rotatividade	vl_faturamento_estimado_aux	vl_faturamento_estimado_grupo_aux	vl_folha_coligados	vl_folha_coligados_gp	vl_frota	vl_idade_maxima_socios_pj	vl_idade_media_socios_pj	vl_idade_minima_socios_pj	vl_potenc_cons_oleo_gas	vl_total_tancagem	vl_total_tancagem_grupo	vl_total_veiculos_antt	vl_total_veiculos_antt_grupo	vl_total_veiculos_leves	vl_total_veiculos_leves_grupo	vl_total_veiculos_pesados	vl_total_veiculos_pesados_grupo
0	NaN	NaN	NaN	NaN	DE R$ 300.000.000,01 A R$ 500.000.000,00	DE R$ 300.000.000,01 A R$ 500.000.000,00	BOA	AUTARQUIA ESTADUAL OU DO DISTRITO FEDERAL	ALTA	ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	ACIMA DE 1 ANO	VERDE	2007-08-03	2791.15	NaN	NaN	False	True	False	False	True	False	False	False	False	True	NAO	False	False	False	False	True	True	NaN	NaN	2.0	523.0	836.0	09e95c1a84049001d086470a8f320a19b076f955a89122ff8360ac2e4d6eca5d	2.0	NaN	NaN	23.0	411.0	508.0	282.0	103.0	22.0	10.0	10 a 15	11.243836	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	357.066667	357.066667	NaN	NaN	NaN	NaN	NaN	NaN	99.961009	84.967827	NaN	NaN	25.533333	NaN	NaN	NaN	NaN	25.533333	-6.500000	NaN	NaN	ADMINISTRACAO PUBLICA	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	VALE DO ACRE	RIO BRANCO	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	23.0	18.22	81.78	1812.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	451.0	0.0	451.0	0	1361.0	1361.0	1383.0	NaN	NaN	1361.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	AC	AC	NaN	1361.0	NaN	0.000000	-1.590745	0.000000	327487200.0	327487200.0	NaN	NaN	46132.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4.0	4.0	0.0	0.0
1	NaN	NaN	NaN	NaN	DE R$ 100.000.000,01 A R$ 300.000.000,00	DE R$ 100.000.000,01 A R$ 300.000.000,00	BOA	MUNICIPIO	ALTA	ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	ACIMA DE 1 ANO	VERDE	2004-12-11	1007.87	NaN	NaN	False	False	False	False	True	False	False	False	False	True	SIM	False	False	False	False	False	True	NaN	NaN	54.0	414.0	523.0	dc9d155f5bcd3172031e2ec9431786e8871ff4b0ff4728bb62194ca0842cce3e	123.0	NaN	11.0	59.0	104.0	157.0	129.0	163.0	113.0	132.0	> 20	43.789041	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	526.133333	5014.966667	NaN	NaN	NaN	NaN	NaN	NaN	149.173091	80.756709	NaN	NaN	23.200000	NaN	NaN	NaN	NaN	23.200000	-9.233333	NaN	NaN	OUTROS	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	AGRESTE POTIGUAR	AGRESTE POTIGUAR	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	23.0	57.11	42.89	2352.0	0.0	NaN	NaN	NaN	NaN	8.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1361.0	0.0	1359.0	0	991.0	991.0	1306.0	NaN	NaN	991.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	RN	RN	NaN	991.0	NaN	0.000000	-24.119449	0.000000	176802910.0	176802910.0	NaN	NaN	1309391.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	20.0	20.0	16.0	16.0
2	NaN	NaN	NaN	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	SOCIEDADE SIMPLES LIMITADA	ALTA	SERVICOS DE EDUCACAO	ACIMA DE 1 ANO	VERDE	2005-09-24	688.31	NaN	NaN	False	False	False	False	True	False	False	False	False	True	NAO	False	False	False	False	True	True	NaN	NaN	19.0	9.0	91.0	16843c9ffb920170477118933798510d8d5f00f5c56c1221773356355bded321	2.0	NaN	1.0	10.0	27.0	30.0	20.0	15.0	11.0	3.0	15 a 20	16.389041	NaN	70.0	NaN	NaN	NaN	70.000000	NaN	70.0	NaN	NaN	NaN	NaN	149.033333	149.033333	NaN	NaN	NaN	NaN	NaN	NaN	65.942017	42.166782	NaN	NaN	4.866667	NaN	NaN	NaN	NaN	4.866667	0.000000	NaN	NaN	ENTIDADES EMPRESARIAIS	EDUCACAO	NORTE PIAUIENSE	BAIXO PARNAIBA PIAUIENSE	EDUCACAO	23.0	47.90	52.10	291.0	21.0	NaN	NaN	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	172.0	7.0	172.0	0	119.0	104.0	113.0	NaN	NaN	119.0	NaN	NaN	2.0	NaN	1.0	NaN	NaN	2.0	0.0	NaN	NaN	NaN	NaN	NaN	1.0	NaN	NaN	SERVIÇO	PI	PI	NaN	119.0	NaN	14.423077	5.309735	6.250000	27818640.0	27818640.0	NaN	NaN	60101.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.0	1.0	1.0	1.0
3	NaN	NaN	NaN	NaN	DE R$ 100.000.000,01 A R$ 300.000.000,00	DE R$ 100.000.000,01 A R$ 300.000.000,00	NaN	MUNICIPIO	ALTA	ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	ACIMA DE 1 ANO	VERDE	2005-09-24	1397.47	NaN	NaN	False	False	False	False	True	False	False	False	False	True	NAO	False	False	False	False	False	False	NaN	NaN	8.0	22.0	1794.0	ff045934d90aab184dd15e66daf3b3c97193bda5449298784b664681610609a0	143.0	NaN	16.0	90.0	213.0	352.0	382.0	264.0	199.0	165.0	> 20	39.671233	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	555.766667	555.766667	NaN	NaN	NaN	NaN	NaN	NaN	144.013013	140.449941	NaN	NaN	28.300000	NaN	NaN	NaN	NaN	28.300000	0.966667	NaN	NaN	OUTROS	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	SUDOESTE AMAZONENSE	ALTO SOLIMOES	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	23.0	51.97	48.03	1971.0	0.0	NaN	NaN	NaN	NaN	11.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	142.0	0.0	141.0	1	1829.0	1829.0	1875.0	NaN	NaN	1824.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	AM	AM	NaN	1824.0	NaN	0.000000	-2.453333	0.000000	221518800.0	221518800.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	NaN	0.0
4	372.066667	NaN	172.400000	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	NaN	SOCIEDADE EMPRESARIA LIMITADA	ALTA	PRODUTOS DE AGROPECUARIA	ACIMA DE 1 ANO	VERDE	2005-11-03	707.20	14789028.0	16899028.0	True	False	False	False	True	False	False	False	False	True	NAO	False	False	False	False	False	True	14.0	NaN	153.0	5.0	3.0	a0ce528caab2c62497a548d0ebd9e935143ef81ed7dbf074dcd7e0c7dd50ae11	1.0	3.0	21.0	19.0	26.0	23.0	31.0	26.0	14.0	11.0	> 20	20.268493	372.066667	70.0	243.600000	243.600000	NaN	48.666667	172.400000	36.0	10148652.0	12258652.0	1.0	65.0	134.833333	179.766667	4059460.8	4059460.8	4929676.0	5.633009e+06	1.0	61.5	14.610734	11.000869	2.915806e+06	2.915806e+06	2.933333	210000.0	210000.0	1.0	58.0	2.933333	-0.566667	1772150.4	1772150.4	ENTIDADES EMPRESARIAIS	AGRICULTURA PECUARIA E SERVICOS RELACIONADOS	OESTE POTIGUAR	MOSSORO	AGRICULTURA PECUARIA PRODUCAO FLORESTAL PESCA E AQUICULTURA	23.0	5.14	94.86	614.0	110.0	NaN	NaN	NaN	NaN	NaN	3.0	3.0	3.0	0.0	0.0	0.0	0.0	0.0	3.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	3.0	0.0	0.0	3.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	437.0	63.0	435.0	0	177.0	130.0	120.0	123.0	123.0	175.0	1.0	1.0	4.0	4.0	NaN	3.0	NaN	4.0	0.0	NaN	NaN	NaN	NaN	NaN	3.0	NaN	1.0	AGROPECUARIA	RN	RN	14789028.0	175.0	1.0	36.153846	47.500000	41.042345	28127736.0	28127736.0	5831611.125	5831611.125	488926.0	NaN	NaN	NaN	6.0	NaN	NaN	NaN	NaN	12.0	12.0	3.0	3.0
5	92.100000	NaN	92.100000	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	SOCIEDADE EMPRESARIA LIMITADA	ALTA	SERVICOS ADMINISTRATIVOS	ACIMA DE 1 ANO	VERDE	2005-09-24	2508.11	930000.0	1140000.0	True	True	False	False	True	False	False	False	False	True	NAO	False	False	False	False	True	True	NaN	NaN	3.0	128.0	4.0	77ed856930ed9c2b5348eca951d152b5655c98af3bb44616674eaaa17846c7c7	NaN	3.0	22.0	32.0	29.0	27.0	15.0	3.0	3.0	1.0	> 20	20.030137	92.100000	61.0	92.100000	92.100000	NaN	46.500000	92.100000	32.0	930000.0	1140000.0	1.0	0.0	48.733333	48.733333	NaN	NaN	930000.0	1.140000e+06	1.0	0.0	39.171605	17.072138	NaN	NaN	22.700000	930000.0	1140000.0	1.0	0.0	23.466667	-0.500000	NaN	NaN	ENTIDADES EMPRESARIAIS	SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO E OUTROS SERVICOS PRESTADOS PRINCIPALMENTE AS EMPRESAS	VALE DO ACRE	RIO BRANCO	ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES	48.0	49.63	50.37	396.0	0.0	NaN	NaN	NaN	NaN	2.0	1.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	261.0	0.0	261.0	7	135.0	135.0	189.0	0.0	0.0	135.0	1.0	1.0	2.0	1.0	1.0	1.0	NaN	2.0	0.0	NaN	NaN	NaN	NaN	NaN	2.0	NaN	1.0	SERVIÇO	AC	AC	930000.0	135.0	1.0	0.000000	-28.571429	0.000000	19679112.0	19679112.0	NaN	NaN	141536.0	NaN	NaN	NaN	6.0	NaN	NaN	NaN	NaN	2.0	4.0	3.0	3.0
6	NaN	NaN	NaN	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	CONDOMINIO EDILICIO	ALTA	SERVICOS ADMINISTRATIVOS	ACIMA DE 1 ANO	VERDE	1999-12-06	1185.57	NaN	NaN	False	True	False	False	True	False	False	False	False	True	SIM	False	False	False	False	False	False	NaN	NaN	4.0	77.0	25.0	099927213e8cf60291e8241bc78a1d92da8fbb2826ae30b45cad02dcc2ea19ba	3.0	NaN	9.0	15.0	18.0	24.0	22.0	4.0	8.0	3.0	15 a 20	18.906849	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	322.200000	5027.166667	NaN	NaN	NaN	NaN	NaN	NaN	93.833962	78.721077	NaN	NaN	3.933333	NaN	NaN	NaN	NaN	3.933333	-0.533333	NaN	NaN	ENTIDADES SEM FINS LUCRATIVOS	SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS	LESTE POTIGUAR	NATAL	ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES	23.0	27.36	72.64	514.0	11.0	NaN	NaN	NaN	NaN	15.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	408.0	24.0	407.0	0	106.0	119.0	199.0	NaN	NaN	106.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	RN	RN	NaN	106.0	NaN	-10.924370	-46.733668	21.333333	18700308.0	18700308.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	NaN	0.0
7	110.933333	NaN	110.933333	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	SOCIEDADE EMPRESARIA LIMITADA	ALTA	COMERCIO POR ATACADO	ACIMA DE 1 ANO	VERDE	2004-12-24	1374.23	210000.0	210000.0	True	True	False	False	True	False	False	False	False	True	NAO	False	False	False	False	True	True	NaN	NaN	4.0	21.0	17.0	d85ce0e92df9ddc051b211f1a5e3d9f223d7efd4c992459acf257316ad43609c	2.0	NaN	5.0	5.0	12.0	12.0	3.0	NaN	1.0	2.0	> 20	21.947945	110.933333	58.0	110.933333	110.933333	NaN	44.000000	110.933333	30.0	210000.0	210000.0	NaN	NaN	212.933333	212.933333	NaN	NaN	210000.0	2.100000e+05	NaN	NaN	78.924031	39.840373	NaN	NaN	3.933333	210000.0	210000.0	NaN	NaN	3.933333	-0.566667	NaN	NaN	ENTIDADES EMPRESARIAIS	COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS	NaN	NaN	COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS	24.0	35.71	64.29	161.0	7.0	NaN	NaN	NaN	NaN	NaN	1.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	1.0	0.0	1.0	1.0	0.0	0.0	0.0	118.0	14.0	118.0	5	43.0	52.0	58.0	NaN	NaN	57.0	1.0	1.0	4.0	1.0	1.0	1.0	NaN	4.0	0.0	NaN	NaN	NaN	NaN	NaN	2.0	NaN	1.0	COMERCIO	RO	RO	210000.0	42.0	NaN	-17.307692	-25.862069	30.107527	10261987.0	13538405.0	NaN	NaN	672056.0	NaN	NaN	NaN	6.0	NaN	NaN	NaN	NaN	13.0	13.0	3.0	3.0
8	45.666667	NaN	45.666667	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	SOCIEDADE EMPRESARIA LIMITADA	ALTA	COMERCIO VAREJISTA	ACIMA DE 1 ANO	VERDE	2004-04-24	NaN	210000.0	210000.0	False	False	False	False	True	False	False	False	False	False	NAO	False	False	False	False	False	True	NaN	NaN	14.0	64.0	16.0	ccbfe46d5e42b751ffe2a742680e853f50ac12e9399c2ecc0538d68f5c1ed6b2	NaN	5.0	16.0	28.0	16.0	11.0	13.0	1.0	2.0	2.0	15 a 20	19.610959	45.666667	45.0	45.666667	45.666667	NaN	41.666667	45.666667	39.0	210000.0	210000.0	NaN	NaN	170.300000	170.300000	NaN	NaN	210000.0	2.100000e+05	NaN	NaN	48.918440	24.691643	NaN	NaN	2.166667	210000.0	210000.0	NaN	NaN	2.166667	-0.433333	NaN	NaN	ENTIDADES EMPRESARIAIS	COMERCIO VAREJISTA	NaN	NaN	COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS	26.0	23.40	76.60	352.0	28.0	NaN	NaN	NaN	NaN	NaN	1.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	1.0	0.0	0.0	1.0	0.0	0.0	0.0	258.0	20.0	258.0	1	94.0	87.0	99.0	NaN	NaN	94.0	1.0	1.0	3.0	1.0	1.0	2.0	NaN	3.0	0.0	NaN	NaN	NaN	NaN	NaN	3.0	NaN	1.0	COMERCIO	RO	RO	210000.0	94.0	NaN	8.045977	-5.050505	22.222222	26067096.0	26277096.0	NaN	NaN	217142.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11.0	11.0	5.0	5.0
9	NaN	NaN	NaN	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	MUNICIPIO	ALTA	ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL	ACIMA DE 1 ANO	AZUL	2005-10-14	353.66	NaN	NaN	False	False	False	False	True	False	False	False	False	True	SIM	False	False	False	False	False	True	NaN	NaN	35.0	53.0	63.0	3aafa3a1f12f483740a52956af100223333d0e3c79bf2ce341896dd554e72293	14.0	NaN	NaN	NaN	8.0	18.0	29.0	22.0	31.0	29.0	> 20	43.854795	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	506.966667	5014.966667	NaN	NaN	NaN	NaN	NaN	NaN	189.020309	316.503220	NaN	NaN	31.333333	NaN	NaN	NaN	NaN	31.333333	8.733333	NaN	NaN	OUTROS	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	CENTRO NORTE PIAUIENSE	VALENCA DO PIAUI	ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL	23.0	73.51	26.49	176.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	25.0	0.0	25.0	0	151.0	151.0	151.0	NaN	NaN	151.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	PI	PI	NaN	151.0	NaN	0.000000	0.000000	0.000000	24418584.0	24418584.0	NaN	NaN	87223.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.0	1.0	2.0	2.0

Last rows

	coligada_mais_antiga_ativa	coligada_mais_antiga_baixada	coligada_mais_nova_ativa	coligada_mais_nova_baixada	de_faixa_faturamento_estimado	de_faixa_faturamento_estimado_grupo	de_indicador_telefone	de_natureza_juridica	de_nivel_atividade	de_ramo	de_saude_rescencia	de_saude_tributaria	dt_situacao	empsetorcensitariofaixarendapopulacao	faturamento_est_coligados	faturamento_est_coligados_gp	fl_antt	fl_email	fl_epp	fl_ltda	fl_matriz	fl_me	fl_mei	fl_optante_simei	fl_optante_simples	fl_passivel_iss	fl_rm	fl_sa	fl_simples_irregular	fl_spa	fl_st_especial	fl_telefone	fl_veiculo	grau_instrucao_macro_analfabeto	grau_instrucao_macro_desconhecido	grau_instrucao_macro_escolaridade_fundamental	grau_instrucao_macro_escolaridade_media	grau_instrucao_macro_escolaridade_superior	id	idade_acima_de_58	idade_ate_18	idade_de_19_a_23	idade_de_24_a_28	idade_de_29_a_33	idade_de_34_a_38	idade_de_39_a_43	idade_de_44_a_48	idade_de_49_a_53	idade_de_54_a_58	idade_emp_cat	idade_empresa_anos	idade_maxima_coligadas	idade_maxima_socios	idade_media_coligadas	idade_media_coligadas_ativas	idade_media_coligadas_baixadas	idade_media_socios	idade_minima_coligadas	idade_minima_socios	max_faturamento_est_coligados	max_faturamento_est_coligados_gp	max_filiais_coligados	max_funcionarios_coligados_gp	max_meses_servicos	max_meses_servicos_all	max_vl_folha_coligados	max_vl_folha_coligados_gp	media_faturamento_est_coligados	media_faturamento_est_coligados_gp	media_filiais_coligados	media_funcionarios_coligados_gp	media_meses_servicos	media_meses_servicos_all	media_vl_folha_coligados	media_vl_folha_coligados_gp	meses_ultima_contratacaco	min_faturamento_est_coligados	min_faturamento_est_coligados_gp	min_filiais_coligados	min_funcionarios_coligados_gp	min_meses_servicos	min_meses_servicos_all	min_vl_folha_coligados	min_vl_folha_coligados_gp	natureza_juridica_macro	nm_divisao	nm_meso_regiao	nm_micro_regiao	nm_segmento	nu_meses_rescencia	percent_func_genero_fem	percent_func_genero_masc	qt_admitidos	qt_admitidos_12meses	qt_alteracao_socio_180d	qt_alteracao_socio_365d	qt_alteracao_socio_90d	qt_alteracao_socio_total	qt_art	qt_coligadas	qt_coligados	qt_coligados_agropecuaria	qt_coligados_atividade_alto	qt_coligados_atividade_baixo	qt_coligados_atividade_inativo	qt_coligados_atividade_medio	qt_coligados_atividade_mt_baixo	qt_coligados_ativo	qt_coligados_baixada	qt_coligados_ccivil	qt_coligados_centro	qt_coligados_comercio	qt_coligados_epp	qt_coligados_exterior	qt_coligados_inapta	qt_coligados_industria	qt_coligados_ltda	qt_coligados_matriz	qt_coligados_me	qt_coligados_mei	qt_coligados_nordeste	qt_coligados_norte	qt_coligados_nula	qt_coligados_sa	qt_coligados_serviço	qt_coligados_sudeste	qt_coligados_sul	qt_coligados_suspensa	qt_desligados	qt_desligados_12meses	qt_ex_funcionarios	qt_filiais	qt_funcionarios	qt_funcionarios_12meses	qt_funcionarios_24meses	qt_funcionarios_coligados	qt_funcionarios_coligados_gp	qt_funcionarios_grupo	qt_ramos_coligados	qt_regioes_coligados	qt_socios	qt_socios_coligados	qt_socios_feminino	qt_socios_masculino	qt_socios_pep	qt_socios_pf	qt_socios_pj	qt_socios_pj_ativos	qt_socios_pj_baixados	qt_socios_pj_inaptos	qt_socios_pj_nulos	qt_socios_pj_suspensos	qt_socios_st_regular	qt_socios_st_suspensa	qt_ufs_coligados	setor	sg_uf	sg_uf_matriz	sum_faturamento_estimado_coligadas	total	total_filiais_coligados	tx_crescimento_12meses	tx_crescimento_24meses	tx_rotatividade	vl_faturamento_estimado_aux	vl_faturamento_estimado_grupo_aux	vl_folha_coligados	vl_folha_coligados_gp	vl_frota	vl_idade_maxima_socios_pj	vl_idade_media_socios_pj	vl_idade_minima_socios_pj	vl_potenc_cons_oleo_gas	vl_total_tancagem	vl_total_tancagem_grupo	vl_total_veiculos_antt	vl_total_veiculos_antt_grupo	vl_total_veiculos_leves	vl_total_veiculos_leves_grupo	vl_total_veiculos_pesados	vl_total_veiculos_pesados_grupo
556	NaN	NaN	NaN	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 30.000.000,01 A R$ 100.000.000,00	BOA	SOCIEDADE EMPRESARIA LIMITADA	ALTA	COMERCIO E REPARACAO DE VEICULOS	ACIMA DE 1 ANO	VERDE	2005-11-03	1660.52	NaN	NaN	False	False	False	False	True	False	False	False	False	False	NAO	False	False	False	False	False	True	NaN	NaN	15.0	32.0	10.0	35bbd387f8a4cf454f781fbb75952f7efcadd9dabdfc6b5724fb110c96a74c37	4.0	1.0	3.0	8.0	8.0	5.0	4.0	9.0	13.0	2.0	> 20	40.720548	NaN	79.0	NaN	NaN	NaN	59.500000	NaN	40.0	NaN	NaN	NaN	NaN	359.066667	359.066667	NaN	NaN	NaN	NaN	NaN	NaN	123.556140	98.280351	NaN	NaN	7.666667	NaN	NaN	NaN	NaN	7.666667	0.766667	NaN	NaN	ENTIDADES EMPRESARIAIS	COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS	OESTE POTIGUAR	MOSSORO	COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS	23.0	15.79	84.21	95.0	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	38.0	4.0	38.0	2	57.0	60.0	63.0	NaN	NaN	141.0	NaN	NaN	2.0	NaN	NaN	2.0	1.0	2.0	0.0	NaN	NaN	NaN	NaN	NaN	2.0	NaN	NaN	COMERCIO	RN	RN	NaN	57.0	NaN	-5.000000	-9.523810	6.837607	24212520.0	56646990.0	NaN	NaN	100694.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4.0	16.0	1.0	1.0
557	NaN	NaN	NaN	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	CONDOMINIO EDILICIO	ALTA	SERVICOS ADMINISTRATIVOS	ACIMA DE 1 ANO	VERDE	2007-02-08	1149.72	NaN	NaN	False	True	False	False	True	False	False	False	False	True	SIM	False	False	False	False	True	True	1.0	NaN	16.0	60.0	28.0	1e36b2c6ecf8630e2f7c02cd759a81ad2e7acc8bf773b1aacf31c7daf3fac711	3.0	1.0	11.0	22.0	19.0	21.0	14.0	5.0	7.0	2.0	10 a 15	11.726027	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	442.266667	442.266667	NaN	NaN	NaN	NaN	NaN	NaN	76.508254	50.578340	NaN	NaN	2.200000	NaN	NaN	NaN	NaN	2.200000	-0.366667	NaN	NaN	ENTIDADES SEM FINS LUCRATIVOS	SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS	LESTE POTIGUAR	NATAL	ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES	23.0	16.19	83.81	257.0	11.0	NaN	NaN	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	152.0	5.0	152.0	0	105.0	99.0	119.0	NaN	NaN	105.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	RN	RN	NaN	105.0	NaN	6.060606	-11.764706	4.901961	21327624.0	21327624.0	NaN	NaN	265726.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	0.0	0.0	0.0
558	634.300000	NaN	14.566667	NaN	DE R$ 500.000.000,01 A 1 BILHAO DE REAIS	DE R$ 500.000.000,01 A 1 BILHAO DE REAIS	BOA	SOCIEDADE ANONIMA ABERTA	ALTA	ELETRICIDADE E GAS	ACIMA DE 1 ANO	VERDE	2005-11-03	1777.60	7.780736e+09	9.656361e+09	False	False	False	False	True	False	False	False	False	False	SIM	False	False	False	False	False	True	NaN	NaN	64.0	333.0	372.0	feb26abd3bfc64f12982f55a2368816d6ecb7e008965c2dc02a73dd75dada2bc	35.0	8.0	46.0	118.0	144.0	161.0	108.0	37.0	52.0	60.0	> 20	52.035616	634.300000	65.0	129.215196	129.215196	NaN	55.500000	14.566667	41.0	1.999183e+09	2.629286e+09	135.0	3907.0	506.433333	506.433333	313031800.0	572342800.0	1.144226e+08	1.420053e+08	8.861111	383.071429	139.020260	166.426737	3.307499e+07	5.637028e+07	2.733333	164000.0	210000.0	1.0	1.0	2.733333	-0.066667	185457.6	61819.2	ENTIDADES EMPRESARIAIS	ELETRICIDADE GAS E OUTRAS UTILIDADES	LESTE POTIGUAR	NATAL	ELETRICIDADE E GAS	24.0	24.71	75.29	1421.0	51.0	NaN	NaN	NaN	NaN	65.0	68.0	68.0	0.0	0.0	0.0	0.0	0.0	0.0	68.0	0.0	0.0	0.0	2.0	0.0	0.0	0.0	48.0	0.0	68.0	0.0	0.0	6.0	0.0	0.0	56.0	18.0	62.0	0.0	0.0	651.0	90.0	649.0	29	770.0	815.0	857.0	3986.0	10726.0	788.0	14.0	2.0	13.0	164.0	2.0	8.0	9.0	11.0	2.0	2.0	0.0	0.0	0.0	0.0	10.0	NaN	6.0	INDUSTRIA	RN	RN	7.780736e+09	769.0	319.0	-5.521472	-10.151692	11.399620	500805000.0	516073630.0	7.937997e+08	1.578368e+09	9215811.0	22.661191	21.86037	21.059548	NaN	NaN	NaN	NaN	NaN	167.0	168.0	16.0	16.0
559	481.033333	NaN	99.566667	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	SOCIEDADE EMPRESARIA LIMITADA	ALTA	COMERCIO VAREJISTA	ACIMA DE 1 ANO	VERDE	2005-08-27	3071.98	8.209219e+06	9.349219e+06	False	False	False	False	True	False	False	False	False	False	SIM	False	False	False	False	False	True	NaN	NaN	2.0	64.0	3.0	6c0463d509136d232f05962554b6c3e94c04c1627ad9a3441548441e3aee97ed	1.0	1.0	3.0	15.0	11.0	14.0	7.0	7.0	8.0	2.0	> 20	42.723288	481.033333	71.0	264.744444	264.744444	NaN	49.666667	99.566667	37.0	7.789219e+06	8.719219e+06	1.0	48.0	444.300000	5064.700000	2596406.5	2596406.5	2.736406e+06	3.116406e+06	1.000000	24.000000	96.749758	37.178795	2.596406e+06	2.596406e+06	7.166667	210000.0	210000.0	1.0	0.0	7.166667	-0.733333	2596406.5	2596406.5	ENTIDADES EMPRESARIAIS	COMERCIO VAREJISTA	CENTRO AMAZONENSE	MANAUS	COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS	24.0	59.42	40.58	449.0	2.0	NaN	NaN	NaN	NaN	1.0	3.0	3.0	0.0	0.0	0.0	0.0	0.0	0.0	3.0	0.0	0.0	0.0	2.0	0.0	0.0	0.0	0.0	0.0	3.0	0.0	0.0	0.0	3.0	0.0	0.0	1.0	0.0	0.0	0.0	380.0	7.0	380.0	9	69.0	75.0	99.0	48.0	48.0	117.0	3.0	1.0	3.0	3.0	1.0	2.0	NaN	3.0	0.0	NaN	NaN	NaN	NaN	NaN	3.0	NaN	1.0	COMERCIO	AM	AM	8.209219e+06	69.0	2.0	-8.000000	-30.303030	9.790210	21018528.0	29660482.0	2.596406e+06	2.596406e+06	294723.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6.0	6.0	1.0	1.0
560	56.200000	NaN	56.200000	NaN	DE R$ 30.000.000,01 A R$ 100.000.000,00	DE R$ 30.000.000,01 A R$ 100.000.000,00	BOA	SOCIEDADE EMPRESARIA LIMITADA	ALTA	SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS	ACIMA DE 1 ANO	VERDE	2006-02-01	NaN	9.300000e+05	9.300000e+05	False	True	False	False	True	False	False	False	False	True	SIM	False	False	False	False	True	False	NaN	NaN	150.0	127.0	2.0	f3b468c4066fac0d2de28bdafa87ec8b9d103a085cf7de5891b7bafbd7fe7cfc	34.0	NaN	6.0	21.0	26.0	45.0	41.0	43.0	44.0	19.0	10 a 15	12.745205	56.200000	49.0	56.200000	56.200000	NaN	41.000000	56.200000	33.0	9.300000e+05	9.300000e+05	NaN	NaN	5099.066667	5099.066667	NaN	NaN	9.300000e+05	9.300000e+05	NaN	NaN	173.809677	61.097177	NaN	NaN	20.733333	930000.0	930000.0	NaN	NaN	24.700000	-0.566667	NaN	NaN	ENTIDADES EMPRESARIAIS	SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICAS	CENTRO AMAZONENSE	MANAUS	ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS	23.0	63.44	36.56	981.0	0.0	NaN	NaN	NaN	NaN	NaN	1.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	1.0	0.0	0.0	1.0	0.0	0.0	0.0	702.0	8.0	702.0	0	279.0	287.0	296.0	NaN	NaN	279.0	1.0	1.0	2.0	1.0	NaN	2.0	NaN	2.0	0.0	NaN	NaN	NaN	NaN	NaN	2.0	NaN	1.0	SERVIÇO	AM	AM	9.300000e+05	279.0	NaN	-2.787456	-5.743243	2.826855	40955220.0	40955220.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	NaN	0.0
561	596.233333	NaN	16.700000	NaN	DE R$ 300.000.000,01 A R$ 500.000.000,00	DE R$ 500.000.000,01 A 1 BILHAO DE REAIS	BOA	SOCIEDADE ANONIMA FECHADA	ALTA	INDUSTRIA DIGITAL	ACIMA DE 1 ANO	VERDE	2008-01-14	5985.49	5.223031e+09	5.451955e+09	False	True	False	False	True	False	False	False	False	True	SIM	True	False	False	False	True	False	NaN	NaN	140.0	2447.0	563.0	251f454db948590c50df496ea83f76e2227e24a32c2814dd00b363fd77754e29	5.0	7.0	643.0	949.0	749.0	444.0	200.0	95.0	41.0	17.0	10 a 15	10.794521	596.233333	72.0	106.631111	106.631111	NaN	52.500000	16.700000	35.0	5.150974e+09	5.372531e+09	275.0	1716.0	30.333333	146.600000	171568880.0	241816100.0	3.482021e+08	3.634637e+08	24.000000	361.600000	23.341541	18.284345	3.669588e+07	5.131406e+07	3.433333	210000.0	210000.0	1.0	10.0	3.433333	-0.466667	288489.6	288489.6	ENTIDADES EMPRESARIAIS	ATIVIDADES DE PRESTACAO DE SERVICOS DE INFORMACAO	NORTE MARANHENSE	AGLOMERACAO URBANA DE SAO LUIS	INFORMACAO E COMUNICACAO	23.0	33.56	66.44	5340.0	465.0	NaN	NaN	NaN	NaN	NaN	15.0	15.0	1.0	0.0	0.0	0.0	0.0	0.0	15.0	0.0	0.0	8.0	1.0	0.0	0.0	0.0	10.0	0.0	15.0	0.0	0.0	4.0	1.0	0.0	10.0	3.0	2.0	0.0	0.0	2168.0	394.0	2162.0	6	3172.0	3186.0	3460.0	1229.0	1808.0	3787.0	7.0	4.0	5.0	28.0	NaN	4.0	NaN	5.0	0.0	NaN	NaN	NaN	NaN	NaN	4.0	NaN	5.0	SERVIÇO	MA	MA	5.223031e+09	3150.0	288.0	-0.439422	-8.323699	12.561773	459934850.0	560530400.0	1.834794e+08	2.565703e+08	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	NaN	0.0
562	58.266667	NaN	58.266667	NaN	DE R$ 30.000.000,01 A R$ 100.000.000,00	DE R$ 30.000.000,01 A R$ 100.000.000,00	NaN	SOCIEDADE EMPRESARIA LIMITADA	ALTA	COMERCIO POR ATACADO	ACIMA DE 1 ANO	VERDE	2003-04-02	NaN	3.770971e+06	3.770971e+06	False	False	False	False	True	False	False	False	False	False	SIM	False	False	False	False	False	True	NaN	NaN	14.0	149.0	5.0	fab2fcabc509768ba2943a21e674fb5af79cb3498730483083054afbb4647cc5	7.0	5.0	13.0	19.0	21.0	35.0	29.0	17.0	12.0	10.0	15 a 20	15.583562	58.266667	53.0	58.266667	58.266667	NaN	53.000000	58.266667	53.0	3.770971e+06	3.770971e+06	NaN	21.0	182.433333	182.433333	1256990.4	1256990.4	3.770971e+06	3.770971e+06	NaN	21.000000	50.483333	24.674931	1.256990e+06	1.256990e+06	2.233333	3770971.2	3770971.2	NaN	21.0	2.233333	-0.666667	1256990.4	1256990.4	ENTIDADES EMPRESARIAIS	COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS	CENTRO AMAZONENSE	MANAUS	COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS	23.0	13.69	86.31	606.0	44.0	NaN	NaN	NaN	NaN	1.0	1.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	436.0	42.0	436.0	0	170.0	173.0	177.0	21.0	21.0	168.0	1.0	1.0	2.0	1.0	NaN	1.0	NaN	2.0	0.0	NaN	NaN	NaN	NaN	NaN	1.0	NaN	1.0	COMERCIO	AM	AM	3.770971e+06	168.0	NaN	-1.734104	-3.954802	24.852071	53164510.0	53164510.0	1.256990e+06	1.256990e+06	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	0.0	18.0	18.0
563	536.733333	NaN	346.366667	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	SOCIEDADE EMPRESARIA LIMITADA	ALTA	BENS DE CONSUMO	ACIMA DE 1 ANO	AZUL	2005-11-03	814.85	8.281920e+05	1.248192e+06	False	True	False	False	True	False	False	False	False	False	SIM	False	False	False	False	True	True	NaN	NaN	14.0	104.0	9.0	564fde999c34d33a262dad0e1596029b2b5f92e4f0aed68dc1e8d47020bf9c61	5.0	1.0	10.0	23.0	27.0	15.0	17.0	14.0	5.0	10.0	> 20	23.698630	536.733333	60.0	441.550000	441.550000	NaN	58.500000	346.366667	57.0	6.181920e+05	8.281920e+05	1.0	4.0	443.033333	443.033333	247276.8	247276.8	4.140960e+05	6.240960e+05	1.000000	4.000000	87.902100	51.202656	2.472768e+05	2.472768e+05	2.266667	210000.0	420000.0	1.0	4.0	2.266667	-0.433333	247276.8	247276.8	ENTIDADES EMPRESARIAIS	FABRICACAO DE PRODUTOS ALIMENTICIOS	LESTE POTIGUAR	NATAL	INDUSTRIAS DE TRANSFORMACAO	23.0	22.83	77.17	365.0	34.0	NaN	NaN	NaN	NaN	NaN	2.0	2.0	0.0	0.0	0.0	0.0	0.0	0.0	2.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	1.0	0.0	2.0	0.0	0.0	2.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	238.0	19.0	237.0	0	127.0	112.0	153.0	4.0	4.0	127.0	2.0	1.0	2.0	2.0	1.0	1.0	NaN	2.0	0.0	NaN	NaN	NaN	NaN	NaN	2.0	NaN	1.0	INDUSTRIA	RN	RN	8.281920e+05	127.0	2.0	13.392857	-16.993464	15.899582	27658940.0	27658940.0	2.472768e+05	2.472768e+05	72226.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2.0	2.0	2.0	2.0
564	NaN	NaN	NaN	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 100.000.000,01 A R$ 300.000.000,00	NaN	SERVICO SOCIAL AUTONOMO	ALTA	SERVICOS DE EDUCACAO	ACIMA DE 1 ANO	VERDE	2000-04-03	2323.03	NaN	NaN	False	True	False	False	True	False	False	False	False	True	NAO	False	False	False	False	True	True	NaN	NaN	3.0	16.0	73.0	31438f752b4a846638c0acd98c3078d7e1ee83204e0388bb15a61f38b358216c	2.0	NaN	1.0	8.0	18.0	17.0	19.0	16.0	5.0	6.0	15 a 20	18.580822	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	300.466667	373.766667	NaN	NaN	NaN	NaN	NaN	NaN	69.311232	54.917612	NaN	NaN	2.066667	NaN	NaN	NaN	NaN	2.066667	-0.433333	NaN	NaN	ENTIDADES SEM FINS LUCRATIVOS	EDUCACAO	NaN	NaN	EDUCACAO	23.0	59.78	40.22	388.0	5.0	NaN	NaN	NaN	NaN	4.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	296.0	30.0	296.0	10	92.0	118.0	132.0	NaN	NaN	482.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SERVIÇO	RO	RO	NaN	92.0	NaN	-22.033898	-30.303030	28.708134	26530740.0	108877850.0	NaN	NaN	1603418.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	17.0	19.0	2.0	2.0
565	323.066667	NaN	74.166667	NaN	DE R$ 10.000.000,01 A R$ 30.000.000,00	DE R$ 10.000.000,01 A R$ 30.000.000,00	BOA	SOCIEDADE EMPRESARIA LIMITADA	ALTA	INDUSTRIA DA CONSTRUCAO	ACIMA DE 1 ANO	VERDE	2005-11-03	4315.60	6.189792e+06	6.609792e+06	False	False	False	False	True	False	False	False	False	True	SIM	False	False	False	False	False	True	1.0	NaN	69.0	65.0	2.0	8a226339b331b5aec24877a69edc40070b9dd7e71b21943996db577948efaf69	4.0	NaN	14.0	20.0	23.0	20.0	22.0	11.0	14.0	9.0	> 20	41.164384	323.066667	68.0	191.375000	191.375000	NaN	66.500000	74.166667	65.0	5.563728e+06	5.773728e+06	1.0	45.0	258.033333	258.033333	2781864.0	2781864.0	1.547448e+06	1.652448e+06	1.000000	12.000000	36.168613	11.335941	1.442448e+06	1.442448e+06	4.866667	206064.0	210000.0	1.0	0.0	4.866667	-5.566667	103032.0	103032.0	ENTIDADES EMPRESARIAIS	CONSTRUCAO DE EDIFICIOS	CENTRO NORTE PIAUIENSE	TERESINA	CONSTRUCAO	23.0	5.11	94.89	1844.0	14.0	NaN	NaN	NaN	NaN	2.0	4.0	4.0	0.0	0.0	0.0	0.0	0.0	0.0	4.0	0.0	2.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	4.0	0.0	0.0	4.0	0.0	0.0	0.0	2.0	0.0	0.0	0.0	1707.0	5.0	1706.0	6	137.0	128.0	511.0	48.0	48.0	137.0	3.0	1.0	2.0	4.0	1.0	1.0	NaN	2.0	0.0	NaN	NaN	NaN	NaN	NaN	2.0	NaN	2.0	CONSTRUÇÃO CIVIL	PI	PI	6.189792e+06	137.0	2.0	7.031250	-73.189824	3.773585	19782144.0	22572144.0	2.884896e+06	2.884896e+06	100470.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.0	1.0	0.0	0.0

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows